Conditional Formatting

[Hwatsonnn]

Column K has values that may contain a "✓".

When a ✓ is present, I would like the row that the ✓ is on to highlight between Column A and J.

I'm not sure how to carry out the process all the way down the document, 2000 rows or so.

Thanks for any help.

K4=✓, So highlight A4:J4

K72=✓ A72:J72

 

[steve the fish]

Use a CF formula:

=$K1="✓"

applied to

=$A:$J