Conditional formatting by results in two different cells
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
In article ,
Supe wrote:
I want my background to highlight red if the cell in column D AND the cell in
column L are both less than zero.
|