Forum Discussion
Solved
Highlight Duplicates but only from one column
Hello, I have two columns of values in my screenshot. Column D and Column E. Column D has some duplicates and Column E does not. How do look at both columns but only highlight the duplicates ...
Use MATCH() function. See the attached file.
I don't know if I'm missing something here, but I copied that same formula and pasted it as a conditional form custom formula, added the color and it's highlighting the wrong ones
Then attach your file or share via google-drive or OneDrive or Dropbox link.