Conditional formatting for unique values

Question

Hi!

I'm trying to figure out the following: I have a SharePoint list, and I want it to highlight the cells that have unique values (only in one of the columns). It would look something like this:

Name	Date	Colour
John	1 Sep 2022	red
Julie	2 Sep 2022	red
Julie	1 Sep 2022	blue
Stacy	3 Sep 2022	green

In the example above, all the unique values in the "Name" column have conditional formatting applied. Just in that one column.

Is something like this even possible?

Answer 1

Dear ania3,

Good day! Thank you for posting in Microsoft Community. We’re happy to help you.

From your description, it seems that you want to highlight cells which has unique values in SharePoint.

If my understanding above is right, according to our search, JSON code or Javascript may achieve your requirement, Retrieve Unique column values in SharePoint List using JavaScript - TechNet Articles - United States (English) - TechNet Wiki (microsoft.com)

Since our category focus on general troubleshooting and some built-in features in SharePoint Online, to make sure you get professional help, we’d suggest you go to sharepoint-dev - Microsoft Q&A to post a new thread to double-confirm it, which is specific channel to handle such situation. The engineers of relevant teams are more proficient in this code than us. They will focus on your specific scenario and provide specific suggestions.

If the scenario above is not consistent with yours, you can also post back and point that.

Thanks for your cooperation.

Sincerely，

Sukie | Microsoft Community Moderator