Highlight Duplicates with condition

[coolkiran]

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.

 

[coolkiran]

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.

 

[NARAYANK991]

Hi Kiran ,

See if this is OK.

Narayan