Problem with conditional formatting
 

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$3100),($I$32%)) I get no errors but the cell is formatted
even if both conditions are false. Any help?


--
DarrenMPY
------------------------------------------------------------------------
DarrenMPY's Profile: http://www.excelforum.com/member.php...o&userid=36787
View this thread: http://www.excelforum.com/showthread...hreadid=565433

Problem with conditional formatting
 

You don't need the IF( ). All you need is the AND(cond1, cond2)


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565433

Problem with conditional formatting
 

Watch your parentheses:
Either:
=IF(AND(($A$3100),($I$32%)),TRUE)
or
=AND(($A$3100),($I$32%))
or
=AND($A$3100,$I$32%)



DarrenMPY wrote:

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$3100),($I$32%)) I get no errors but the cell is formatted
even if both conditions are false. Any help?

--
DarrenMPY
------------------------------------------------------------------------
DarrenMPY's Profile: http://www.excelforum.com/member.php...o&userid=36787
View this thread: http://www.excelforum.com/showthread...hreadid=565433

--

Dave Peterson