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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hyperlink formatting 2
Advanced conditional formatting 1
Changing Font Colour of row depending on selection made in 1st col 1
Help with date formula and colour change 3
Changing Font Colour 9
Conditional Formatting 2
Macro code to partially format font colour of result in cellcontaining a formula 3
Conditional Format Font Style in Cell 2

Top