• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlight Duplicates with condition

C

coolkiran

Member
Hi

I am trying to highlight a certain rows which have duplicates with condition.

Here is the scenerio.

I have 3 columns A, B, C

I need to highlight rows which has duplicates only in Column A not other columns B and C. Column B and C value should be unique. the values in that columns should not be repeated,

Attached sheet for reference, Is that possible in Macro or Excel formula.
 

Attachments

Thanks Narayan, Its working. But only thing is it will highlight if one column matches, i don't want to hightlight if match found in each column as well.

For example : in the sheet, Change Column C Row 2 to 100 and in Row 5 as 100. Here its matching, but it is highlighting.

I want to highlight column A should be duplicate and Column B should not match with duplicates rows.

If possible let me know.
 
You must log in or register to reply here.
Back
Top