|Subject:||RE: using conditional formatting - blank cells|
|Date:||Tue, 9 May 2006|
I use a good trick. A change the formula to:
Get the result. But a problem. Excel was displaying the 0. Then I uncheck
the "Zero Values" option from Tools - Options - View tab.
Hope this helps you too. Let us know!
> I want to use three colours to highlight a spreadsheet, red for numbers less
> than -1, amber for number between -1 and 0, and green for numbers greater
> than 0 which I can do no problem. Each cell that I am colour formatting has
> the formula (or similar):
> However the blank cells are also being coloured in green when I want them to
> remain white. Any ideas?
using conditional formatting - blank cells posted by sd on Tue, 9 May 2006