conditional formatting - duplicate references

gledister

Board Regular
Joined
Mar 21, 2011
Messages
173
Imagine we have this column:

reference01
reference02
reference02
reference07
reference09
reference09
reference10

And what we want to get highlighted is only what is a duplicated reference...which means in this case the cells getting highlighted are going to be:

reference02
reference02
reference09
reference09

Thanks in advance!
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,109,446
Messages
5,528,802
Members
409,836
Latest member
karnasrinivas
Top