Conditional formatting for unique values

ania3 21 Reputation points
2022-11-02T14:01:07.833+00:00

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:

256409-image.png

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?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,040 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,767 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Xuyan Ding - MSFT 7,561 Reputation points
    2022-11-03T06:45:18.073+00:00

    Hi @ania3 ,

    Unfortunately as far as I know there is currently no way to compare values against other values in the list using JSON formatting. List Formatting can only look at one row at a time.
    If your list is using classic mode, you can try adding web part to achieve this using JS code.
    Here is a similar case for your reference: JSON to highlight duplicate column values in SPO List


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.