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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MKLeisure - 16 Dec 2005 14:49 GMT

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.

Reply to this Message

Ron Coderre - 16 Dec 2005 14:58 GMT

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

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

Reply to this Message

MKLeisure - 16 Dec 2005 15:53 GMT

Yes..Thank you

> Try this:
>
[quoted text clipped - 15 lines]
> > color black. AS an example. IF F2 = "HR", change the text in F@ to red,
> > change it to black.

Reply to this Message