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

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

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error with countif formula on when adding linked spreadsheets 0
change color font after updated 3
Logic Formula using colors in the formula? 2
How to give numbers to the font colors 2
how do i change row font color based on cell value in that row 5
How can I add the values based the color of font and the date 1
How to keep font color when referencing Sheets in the same workboo 4
Change the color of each capital letter in a rich text memo field. 0

Top