Format a cell to recognize data and change font colors accordingly

D

Dwood62

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

William Horton

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
 
Top