Microsoft Excel - Conditional formatting, finding duplicates
I found a solution; it's not "pretty", but it works. Unfortunately, it is a bit hard to describe, so I'll make an
example file with explanations available, instead. In short, it uses


a "helper cell" the locate and mark duplicates
Excel's use a formula to determine which cells to format Conditional Formatting option to then color the original cells