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