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
|