Changing Font Colour if cell is certain word?

**wuming79** · 07-11-2006, 08:15 AM

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.

**MartinShort** · 07-11-2006, 08:25 AM

Use "Conditional Formatting". It's on the Format menu.

**wuming79** · 07-11-2006, 08:45 AM

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

**MartinShort** · 07-11-2006, 09:32 AM

don't use "Formula is", keep it as "Cell Value is" and it should work fine.

Gord Dibben · 07-11-2006, 03:30 PM

Either Formula is:

=cellref="Fail"

or

Cell Value is: equal to Fail

Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 08:45:12 -0400, wuming79
<[email protected]> wrote:

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