Changing Font Colour if cell is certain word?

W

wuming79

Can I make the font of a certain cell change it's font colour to Red if
the word in the cell is, example, "Fail"? I want the change to apply
from B2:F23.
 
W

wuming79

I tried setting it as condition1's formula Is ="Fail" and then chang
the format to Font colour Red, but it did not change the word "Fail" t
red. Is there anything else that I need to define
 
G

Gord Dibben

Either Formula is:

=cellref="Fail"

or

Cell Value is: equal to Fail


Gord Dibben MS Excel MVP
 
Top