Conditional formatting / blank cells
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)
"torkattack" wrote:
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.
|