Have you had a look at <format <conditional formatting

--
Greetings from New Zealand
Bill K

"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?