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: Patten, Colour=orange

Why, when E3 = 0 doesn't the cell colour of A3 change to orange?
I have tried removing the formula in ce;; E3 and entering 0 in case there
was a hidden decimal but no joy.
Itmust 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: Patten, Colour=orange

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

Can anybody put me straight?

TIA
Dave Moore

This works for me.
Are you sure E3 contains a number (i.e. that it is not formatted as text)?

 

[Mark D]

shouldn't make any difference how the cell is formatted, even text should
trigger the format

the conditional should definately work as long as there is nothing else also
affecting that cell

if you want to mail me the spreadsheet or a link to it then I can quickly
check whats happening..

Mark D