You may be able to use condifitonal formatting

Look at


http://www.cpearson.com/excel/Duplicates.aspx


"jchambers" wrote:

I am trying to find a way to show duplicate data with multiple variations of
data. I would like to know if there is a fuction i can set up for this or a
macro that would accomplish this task.