Need help finding and highlighting same values

[NoBob]

Hi,

I need to locate and highlight cells that have the same value in a column, e.g.

000116
000117
000119
000119
000120
000120
000120
000121
000122
000123

Is there a way to highlight the cells (possible to give them a colour to make them easier to locate?) with the same numbers? In the example above they will be the ones with 000119 and 000120 in them?

Thanks.

[MarvinP]

Hi NoBob,

You can use Conditional Formatting to do this job. Read this link for pictures on how to do it.

http://www.excel-easy.com/examples/find-duplicates.html

[NoBob]

Thanks, I'll give it a try when I get back in front of the computer. Hope it's the same on a Mac (working with Excel 2011 and 2016).