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
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