Highlight Row with Duplicate Value in Cell

[srj1359]

I have a data sheet in which column V is hidden, but it contains the formula "A9&F9" (data in the entire sheet starts at row 9). At the moment, I have VBA written to check column V for duplicates and remove the entire row if there is a duplicate value.

I want to change this to check column V for duplicates and highlight the entire row if there is a duplicate value. Can someone please help me with this?

Thank you so much!

 

[etaf]

countif($V9:$V200,$V9)>0

select the range A9 to V ???? I have set to row 200 - but change to your max rows

then add the formula as a conditional format rule

 

[srj1359]

Hi @etaf ,

Columns A-AK are in use, though there are a few hidden throughout that range.

The number of rows will vary, so I think I would need to include something like:

endrow = Range("A" & Rows.count).End(xlUp).Row

Though I'm not quite sure how to fit that in to your proposed idea.

 

[etaf]

its been so long since i worked with VBA , I missed that in the question , sorry about that