Check out Conditional Formatting at Debra Dalgleish's Contextures website:
http://www.contextures.com/xlCondFormat01.html
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Wullie" wrote:
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?