How do I set cell colors based on if query
 

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?

How do I set cell colors based on if query
 

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?

How do I set cell colors based on if query
 

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?

How do I set cell colors based on if query
 

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?