Check out *Conditional Formatting* in Help then, (in XL97 at least):

*Highlight data that meets conditions you specify*

And finally

*Apply conditional formats to cells*

--
HTH

Sandy

with @tiscali.co.uk


"Wullie" wrote in message
...
I am trying to write a formula that will set the cell one colour if true or
another if false.

Is this possible and how do I do it?