I have a large amount of data, >800,000 rows, with duplicates in the combined data from both column C and Column D. If the same data is in both Col C and Col D, the row is considered a duplicate.
Need to visually display the duplicates for research purposes. Only the data in C & D need to be colored.
Given the large number of duplicates, need to use RGB colors to expand the color options...below seems to provide good color scheme results. Trying to balance speed and accuracy...How do I best do this with a large data set?
iR = WorksheetFunction.RandBetween(51, 255)
iG = WorksheetFunction.RandBetween(102, 255)
iB = WorksheetFunction.RandBetween(51, 255)
DuplicateCells.Interior.Color = RGB(iR, iG, iB) 'This is just an example