Conditional formatting - highlight cell based on specific text anywhere in entire row

[SaraWitch]

Hello peeps.

I am applying a conditional format to highlight a cell (A1) if specific text ('N') is anywhere in entire row. The formula I'm using is:

=$K1:$NL1="N" (which is applied to A1)

But this only works when 'N' is selected in K1, and not in any other cells in that row.

I'm sure I'm missing something that is staring me in the face, but any help would be appreciated...

 

[Fluff]

Try

=COUNTIFS($K1:$NL1,"N")

 

[SaraWitch]

Spot on! Perfect; thank you for your help, @Fluff , as always! ?

 

[Fluff]

You're welcome & thanks for the feedback.