Format a cell

[Shawn]

I want a cell to be highlighted in one color and when I enter some text, such
as a number, I want it to change to a different color. How do I do something
like that.

Thanks

 

[challa prabhu]

Hi,

For more information on Conditional Formatting, refer to this link:
http://office.microsoft.com/en-us/excel/HA011366251033.aspx?pid=CL100570551033

Challa Prabhu