Hi, Hope you can help.
I have a worksheet with thousands of values (in B:B). Not all cell values are different. Some cells are unique, but some cells have identical values.
I have a list of unique values (in F:F). When I select a cell in F:F, I'd like to change all other identical values in the worksheet to color(7).
I have this I found here, but it only highlights the current selection.
Many ThanksPlease Login or Register to view this content.
Bookmarks