SOLVED

Conditional Format only if Another Cell Says X

New Contributor

In column E I have the preset color as green and I am happy with that. What I want from the Yellow and Red is I only want it to format the numbers if they are also listed a a "FLO" user in column B. The Yellow is set for <60 and the red is set for <30 

 

What kind of formula could I use for that?

CaitlynEXCEL_0-1659483334001.png

CaitlynEXCEL_1-1659483840219.png

 

1 Reply
best response confirmed by CaitlynEXCEL (New Contributor)
Solution

@CaitlynEXCEL 

You have to use AND() function. Try Custom Formula in CF rules like

 

=AND($B1="FLO",$E1<60)  'This formula for yellow.
=AND($B1="FLO",$E1<30) 'This formula for red.