Conditional Formatting

  • Thread starter Thread starter DaveMoore
  • Start date Start date
D

DaveMoore

Cell E3 has a formula producing a value of 0

I want to conditionally format cell A3 thus:
Condition1, Formula is =E3=0
Format of cell when true: Pattern, Colour=orange

Why, when E3 = 0 doesn't the cell colour of A3 change to orange?
I have tried removing the formula in cell E3 and entering 0 in case
there was a hidden decimal, but no joy.
It must be the conditional formula I have entered that is incorrect.

Can anybody put me straight?

TIA
Dave Moore

PS. I've been trying to send this message for some 5 days now.
Apologies to the newsgroup for the test messages from my provider, ukonline,
and from myself.
 
Hi Dave,
And what about my asking what was selected and what was the
active cell when you entered the formula. Did you look at
my web page condfmt.htm

The formula you create for Conditional Formatting is based
on the cell that is currently active. The cells affected (to be
colored) are those in the Selection Range. This distinction is
very important to being able to understand and use of Conditional Formatting.

Or perhaps the value in $E3 just looks like zero, due to a formatting
showing dollars and cents, for instance..

Select Cell A3
Format, Conditional Format
Formula1 is: =ABS($E3)<.01

By using $E you can color more than just column A
 
Back
Top