D
Dave Moore
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 coloour 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 coloour 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