I am trying to color a character field based on whether or not there are multiple occurrences in the table. For example, if i have a list of names and some of them appear multiple times, I'd like to make the background a different color than the ones with only one occurrence. It's basically the same as the conditional formatting in Excel for multiple occurrences. Is there a way to do this?
