Google Docs - Highlight duplicate values in cell range

In Google Docs "If a duplicate value is found, highlight it".  How do I do this?
Who is Participating?
Ted, There is no direct way of doing it.

To determine duplicates, add a column say B and place this formula in B1. I am assuming that the data is in Col A


Copy the formula for all B cells that are adjacent to A cells containing data.

A TRUE value in the B column tells you that the value in the A column is a duplicate.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.