Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting / blank cells | Excel Discussion (Misc queries) | |||
conditional formatting for blank cells | Excel Discussion (Misc queries) | |||
Conditional formatting/non blank cells | Excel Worksheet Functions | |||
Conditional Formatting Not Blank Cells | Excel Discussion (Misc queries) | |||
using conditional formatting - blank cells | Excel Discussion (Misc queries) |