Use conditional formatting. Look at 'Highlight cells that meet specific
conditions' in the Answer wizard in help


--
HTH

Bob Phillips

"Cambronze" wrote in message
...
What I am trying to do is use a list of products in my spread sheets.
When
an item is duplicated under another heading then I want to highlight it