conditional formatting in RTF for duplicate

Summary:

Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once?

Content (please ensure you mask any confidential information):

Say we have a report where supplier number 123 is present in two different rows. We'd like to highlight both rows with yellow fill. Can we do that? If so, how?

Version (include the version you are using, if applicable):

24D

Code Snippet (add any code snippets that support your topic, if applicable):