Conditional formatting / blank cells

  • Thread starter Thread starter torkattack
  • Start date Start date
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.
 
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)
 
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.
 
Not sure if this is in the right spot, I've never used this before.
But THANK YOU David, it worked perfectly!!!
 
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.
 
Back
Top