How do I change the font color based on results of an IF stateme

M

MKLeisure

In an Excel Work sheet I want to examine the contents if the Division column
and if the division is HR change the Font color to red else leave the font
color black. AS an example. IF F2 = "HR", change the text in F@ to red,
change it to black.
 
R

Ron Coderre

Try this:

Select the cells you want specially formatted
Format>Conditional Formatting
Cell value is equal to ="HR"
Click the [Format...] button
Set the font color to Red
Click [OK]

Does that help?

***********
Regards,
Ron
 
M

MKLeisure

Yes..Thank you

Ron Coderre said:
Try this:

Select the cells you want specially formatted
Format>Conditional Formatting
Cell value is equal to ="HR"
Click the [Format...] button
Set the font color to Red
Click [OK]

Does that help?

***********
Regards,
Ron


MKLeisure said:
In an Excel Work sheet I want to examine the contents if the Division column
and if the division is HR change the Font color to red else leave the font
color black. AS an example. IF F2 = "HR", change the text in F@ to red,
change it to black.
Click to expand...
Click to expand...
 
Top