Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a cell to recognize data and change font colors accordingly
I am wanting to format cells so that automatically recognize the data being
inserted and change the font color. i.e. completed would become green, not completed would become red. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a cell to recognize data and change font colors accordingly
Use conditional formats. Follow the menu path Format / Conditional
Formatting. Then complete the options. Excel help may be useful on this as well. For your example: Cell Value Is - Equal To - ="Completed" Then set the format to what you want. Click add and add a second condition. Cell Value Is - Equal To - ="Not Completed" Then set the format to what you want. ETC Hope this helps. Bill Horton "Dwood62" wrote: I am wanting to format cells so that automatically recognize the data being inserted and change the font color. i.e. completed would become green, not completed would become red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
Remove Data Format Change | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
change font color of first cell in data table attached to chart | Charts and Charting in Excel |