Conditional formatting / blank cells


T

torkattack

I am using a conditional format whereas if the answer is greater than or
equal to 70%, it turns green and then secondly if the answer if less than 70%
it turns red. I want a third condition that if the cell is blank, the colour
will be white, but I can't figure out what to use for the third condition.
Thanks.
 
Ad

Advertisements

S

Sheeloo

To format cell A1 if blank use the following in as the FORMULA IS
=A1=""
(two double quotes without anything between them) or
=ISBLANK(A1)
 
D

David Biddulph

CF/ Formula Is/ =A1=""
but you'd need to put that condition before your <70% condition, or
otherwise that condition would take preference.

You could, of course change the <70% condition to =AND(A1<>"",A1<70%)
In that case, you wouldn't need to test subsequently for blank, so that
could be the default formatting.
 
T

torkattack

Not sure if this is in the right spot, I've never used this before.
But THANK YOU David, it worked perfectly!!!
 
Ad

Advertisements

T

torkattack

Hi David,

I'm trying the same conditional format in another set of cells now and I
can't get it to work again. This time I want a format for:
greater than or equal to 0% - green
less than 0% - red
blank - white.
I can't figure out why the same format won't work again? Does it have
soemthing to do with having a zero or a negative number. Sorry, I'm lost.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top