Highlight Entire Row With Non Contiguous Data If...

[indi visual]

I am looking to highlight an entire row if a matched name is found in Column L (from Column N).


Some of the rows have blanks (hence why I'm looking for something to select the entire row regardless (selecting non contiguous rows).


Any help is appreciated. Thanks.

 

[vasim]

Assumption as follows:


L1 = has the criteria to be matched

N column are the list to be matched with


in this case whereever the L1 value is in N column the entire row is to be highlighted


The below code should work, you can change the range(A1) as suitable.


Sub row_highlight()


Range("A1").FormulaR1C1 = "=MATCH(RC[11],C[13],0)"

Rows(Range("A1")).Select


End Sub

 

[indi visual]

Thanks I really appreciate it.