This worked perfect...I do have another column on another worksheet within
this spreadsheet, is it possible to incoporate another worksheet column into
this formula? Thanks for everything!!!

"Cesar Zapata" wrote:

I hope I understood your question. You can Highlicght duplicated items
with conditional formatting. Lets say your data is in A1:C5

Select your range then go to Formatconditional formatting then select
Value is and change it to "Formula Is".

then type this =IF(COUNTIF($A$1:$C$5,A1)1,TRUE,FALSE)

click on format button and select the colors you like to hightlight the
Dups.

You can find more info here
http://www.cpearson.com/excel/duplicat.htm