| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I change the font color based on results of an IF stateme
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change the font color based on results of an IF stateme
Try this:
Select the cells you want specially formatted FormatConditional 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" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I change the font color based on results of an IF state
Yes..Thank you
"Ron Coderre" wrote: Try this: Select the cells you want specially formatted FormatConditional 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" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change font in a forms control combo box | Excel Discussion (Misc queries) | |||
| can't change font | Excel Worksheet Functions | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| Where to stick macro to change default comment font? | Excel Discussion (Misc queries) | |||
| Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel | |||
Linear Mode
