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

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.