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 in column D, only IF they appear in column E?
Thanks!
Use MATCH() function. See the attached file.
4 Replies
Try this formula
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.
