Colour Changes

[aidanwhite]

Hi,

Using condition formatting, I'd like a cell to go green if '1' or above is entered, go red if '0' is entered, and stay white if the cell is empty.

Please help.

Thanks!

 

[Joe4]

Let's say that cell is A1.
You can enter two Conditional Formatting rules. I like to use the "Formula" option.

Doing that, the first formula would be:

=A1>=1

and choose the green color

The second formula would be:

=AND(A1=0,LEN(A1)=1)

and choose the red option
(we need to check length too to difference 0 from a blank)

 

[aidanwhite]

Perfect.

Thank you!

 

[Joe4]

You are welcome.