Hi,

I'm trying to highlight the entire row with conditional formatting if I=1 and L=DL*.

So far I've tried
=COUNTIFS(I6:I10000="1",L6:L10000="DL*")
=COUNTIF($L6,"*DL*")
=AND($I6="1", $L6="DL*")
=AND($I6=1,$L6="DL*")
=(COUNTIF($I6="1")+COUNTIF($L6="DL*"))
=AND($L6=”DL*”;$I6=1)
And more, but nothing seems to work.

Any help appreciated.