Conditional Formating Question
Hi Terri
=AND(ISNUMBER(A1),A1=0)
format to colour of choice.
No need to do anything about blank, as you want the format to stay "as is"
Regards
Roger Govier
terri wrote:
Have a problem with conditional formating.
What I want it to do is if a cell has a zero input I want it to turn a
color, but if the cell is left blank I want it to stay white, but whatever
I'm doing Excel is reading a zero in a cell and a blank in a cell the same.
Can anyone help?
|