Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello -
I have the following conditions already in conditional formatting for each cell (it merely turns the cell color green - color #35, to be exact): Condition 1 Formula Is =IF(G9="N/A",IF(I9="",TRUE,FALSE),FALSE) Condition 2 Formula Is =IF(G9="No",IF(I9="",TRUE,FALSE),FALSE) Condition 3 Cell Value Is equal to 0 PROBLEM: I have at least one more condition I need to add: If G is blank, turn the corresponding cell in Column I to green If for the last statement there is some way of combining If G="" Or I="0" turn the cell green, that would work, but I can't seem to figure out how to do this. Any help will be greatly appreciated! -- Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - 2 conditions | Excel Discussion (Misc queries) | |||
Conditional formatting should allow more than three conditions. | Excel Discussion (Misc queries) | |||
Conditional formatting with more than 3 conditions. | Excel Worksheet Functions | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Conditional Formatting using two formula conditions | Excel Programming |