Does anybody have any suggestions on how to create a conditional rule that finds non-consecutive duplicates in a column of data (numbers or text)? For example, the data below have been highlighted (red text) showing the desired result. Note that all occurrences need to be formatted.
AB
AB
AB...