If G="" Or I="0" is the same as MAX((G1=""),(I1="0")) as if either are true
the MAX=TRUE=1
--
Gary''s Student


"Sandy" wrote:

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