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?
Bookmarks