Highlight non-repeated data in column"ID" of excel sheet using set range color

Help
1

Hello All,
i have an excel sheet of data contains ID,Name of Employee. i want to highlight the non-repeated ID number using set range color.
Untitled
i’m sharing the screenshot of excel .here i want to highlight the ID no 4,5,6,7 with some different color.

2

Hi,
Here Is my solution :grinning:HighlightRepetedData.xaml (33.1 KB)