View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
torkattack torkattack is offline
external usenet poster
 
Posts: 9
Default Conditional formatting / blank cells

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.