Conditional formatting based on dynamic values

I’m looking for a way to highlight duplicated entries but in a dynamic way.

I have the following formula that checks if the value is duplicated within the current table and highlights those rows if there is a match.


My question is, is it possible to apply a different color to the highlight based on these values? i.e. have duplicates of Item1 colored in red, duplicated of Item2 colored in blue, and so on.

Hi! I created a doc here to show how I think I’d go about this. Let us know if this helps. :smile:


This works if you already have a known set of values. In my case it needs to be dynamic, meaning that the specific values are not known in advance.

Got a working dynamic example for you here, shoutout to @Jono_Bouwmeester


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.