Thread: Problem with conditional formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DarrenMPY DarrenMPY is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote