Is there a way to have Excel look down a column and if it finds matching values color the rows for those one color and them on the next match color in those rows an alternate color?
For example in column D I have values such as:
34826042-1
QUO-109184-J7P1Q5
QUO-109184-J7P1Q5
34736953-1
34736953-1
34736953-1
34736953-1
34736953-1
34736953-1
I'd like it to color the row for 34826042-1 one color and the rows for QUO-109184-J7P1Q5 another. Then revert back to the first color for rows that include 34736953-1.
Trying to find a way to group data by highlighting the row to make it easier to visually decipher. Thanks!
Bookmarks