View Single Post
 
Old 06-02-2011, 02:35 PM
djreyrey djreyrey is offline Windows 7 Office 2007
Novice
 
Join Date: Mar 2010
Posts: 21
djreyrey is on a distinguished road
Default

Hello Tony,

The conditional formatting formula I'm using is: =IF(AND(OR(C4="PRO",C4="SER"),H4=1,I4=0),TRUE)

The data already existed when I applied the conditional formatting down to all rows. I also tried creating the conditional formatting first and then pasting the data but that does not work either. I know the formula works because if I type over the cells, the row highlightes. It just does not highlight if I paste the data or if the conditional formatting is applied to data already in the cells.

Hope this helps!!

Rey
Reply With Quote