Hi, Thanks for any help in advance,
I have attached an example sheet of how I would like it to work (if its possible) - i have colored the cells to show the desired effect of the conditional formatting but there are no formulas in place.
what im trying to get is this - I want to highlight a row of data that contains duplicates in separate columns/tables, so columns A-D is a table of client information, column E is blank and column F is copied & pasted data from another sheet of Client ID's i've already checked off. so i would like the client ID numbers to trigger a duplicate conditional formatting and highlight the rows duplicates are in so I can tell which ID's i have already checked from a crossover sheet.
I dont use VBA so if there are any formulas for this would be so very helpful!!
Bookmarks