I would like to create a format rule that would highlight duplicate data in a column. Example, Column A has the data set:
Then the format rule (underline, bold, whatever) would only apply to “Blue” because it is a duplicate.
Any thoughts? I’m sure there is a simple answer.