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.

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.