Format column so that if a cell has no value then it's blank

[Mr2017]

Hi

I have a column of data where I've added in two conditional formatting rules:

1) if the cell is 0, then the cell is filled with the colour green.

2) if the cell is NOT equal to zero, then the cell is filled with the colour red.

However, the formatting has made blank cells RED, as well!

Is there a way to add in a condition to say if the cell is blank, then fill it with NO COLOUR?

I used the following steps for the first two rules:

Conditional Formatting / Highlight Cells Rules / Equal To ....then selected 0 and chose the green fill.

Conditional Formatting / Highlight Cells Rules / More Rules / Format Only Cells That Contain / Cell Value / Not Equal To ....then selected 0 and chose the RED fill.

I'd be grateful for your thoughts.

Thanks in advance

 

[Joe4]

1) if the cell is 0, then the cell is filled with the colour green.

2) if the cell is NOT equal to zero, then the cell is filled with the colour red.

Use the formula option, and use this formula for your first condition (assuming cell A1):

=AND(A1=0,A1<>"")

 

[Mr2017]

Awesome!!

That worked!!

Thank you @Joe4

 

[Joe4]

You are welcome.