View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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?