S Supe Feb 4, 2009 #1 I want my background to highlight red if the cell in column D AND the cell in column L are both less than zero.
I want my background to highlight red if the cell in column D AND the cell in column L are both less than zero.
J JE McGimpsey Feb 4, 2009 #2 One way: Assume the cell to have the CF applied is in Row 2: CF: Formula is =AND($D2<0,$L2<0)) Format1: <pattern>/<red>
One way: Assume the cell to have the CF applied is in Row 2: CF: Formula is =AND($D2<0,$L2<0)) Format1: <pattern>/<red>
