Problem with conditional formatting

D

DarrenMPY

I am trying to apply background color to a range of cells if two
conditions are true. I have resorted to formatting each cell in the
range with the same "formula is" conditional format. My formula is
=IF(AND($A$3>100),($I$3>2%)) I get no errors but the cell is formatted
even if both conditions are false. Any help?
 
D

Dave Peterson

Watch your parentheses:
Either:
=IF(AND(($A$3>100),($I$3>2%)),TRUE)
or
=AND(($A$3>100),($I$3>2%))
or
=AND($A$3>100,$I$3>2%)
 
Top