View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Conditional formatting / blank cells

What I mean is that the first CF condition that you specify should be the
blank condition.
Then add the conditions for = and for < (though in fact you could set the
default format to be red and not bother with the < condition).
--
David Biddulph

"torkattack" wrote in message
...
Thank you David, however I am not an expert and unfortuantely I do not
know
what you mean at all. Torkattack

"David Biddulph" wrote:

Test for the blank first.
--
David Biddulph

"torkattack" wrote in message
...
Hello, I need help with a Conditional Format.
This is my worksheet.

Row 4 A B C D E F G H I
$200 $210

I want a conditional format in G4 that states if G4 is greater than or
equal
to F4 the fill colour is green. If G4 is less than F4, the fill colour
is
red. If G4 is blank, the fill colour is white. I've tried numerous
combinations, but cannot seem to get this to work. Thanks torkattack.



.