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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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...
 
Back
Top