Format duplicated value on SharePoint Online

Andy 1,351 Reputation points
2023-02-24T02:08:52.6233333+00:00

We want to highlight duplicate values on a column via JSON formatting like in Excel, but cannot find a proper rule, anyone know how to do that?

SharePoint Online:

User's image

User's image

Microsoft 365 and Office SharePoint For business Windows
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 51,836 Reputation points Microsoft External Staff
    2023-02-24T11:01:08.5133333+00:00

    List JSON Formatting only can work at one row at a time, it cannot work in a whole column. Unfortunately, there is no option to achieve this in the SharePoint 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.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.