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

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.



.