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.