Hi friend,

You can do so by using the conditional formatting

Hope you know how to use the conditinal formating.
Say you want the A:A column to seach for the duplicates
1. Select A1 then,
In FomatConditional Formating select Formula Is and type the formula

=countif(A:A,A1)1

2. Click Format button
3. Go to Patterns tab, select a colour (say Red)
4. Click Ok
5. Copy A1 and select the whole column
6. Right click your mouse button, select Paste Special, select formats

You will find the duplicate values in Red colour

You can repeat this for each of your columns


Hope this works fine with you

Shail




Niagera College Student wrote:
I am currently gathering a lot of data; I have been referencing several list
that may contain the same information. Is there a way to have Excel show me
if there are any duplications in a select row or column??