Conditional Formatting

[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

 

[Anon]

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

I replied earlier to a similar thread. Please don't start a new one, but
continue the old so that everyone knows what's been suggested and tried
before. Did you check if E3 is formatted as text? I haven't seen your reply
if you did.