Forum Discussion
Solved
Conditional Format only if Another Cell Says X
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. ...
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.
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.