This feature in XL is called "Conditional Formatting".

Look it up in the Help files, and post back if you need help.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Al" wrote in message
...
How do I get the text in a cell to automatically change colour when a
particular formula or function result is achieved. E.g. logical function
result "TRUE" auto text colour change to green?