Excel Conditional Statement

[DaveNamou]

How can I make a cell show in a certain color (red) when the cell has the word "TEST" in it.

So, if a user types the word TEST in the cell, it automaticlaly changes the font to a red color.

I hope this is an easy question...

Thank YOU Dave Namou, MCSE CCEA

 

[mahasamatman]

The quick way I did this ...

click the select all button (or press control A to select all).
Click "Format" on the menu bar.
Select "Conditional Formatting".
What you want it to say is "Cell Value is" "equal to" "TEST" -> then click the format button and select red as the text color (on the font tab).

Click "okay", "okay". That's it.

 

[DaveNamou]

That was cool!!
I didn't even know that feature was there.

Thanks a bunch!!! Dave Namou, MCSE CCEA