Hi, I'd just like to clarify what you mean by duplicate values and unique coloring. Do you mean;
1) Any value that matches a specific reference value, or
2) Any value in column F that is equal to another value in column F
I'm guessing 2, so would you want each GROUP of duplicate numbers to be a different color?
EDIT: Also, I'm assuming you meant row 1 is the header not column A?
Bookmarks