Duplicates found over two columns

[Samberlina]

Please someone help.
I am trying to highlight duplicate entries within a spreadsheet with many columns. I need to highlight the first column if an entry is returned as duplicate in both column A & B.

Any suggestions?
(I tried the countif formula, but, this just highlighted rows above and below the entries I actually needed).
Thanks in advance.

[oldchippy]

Please someone help.
I am trying to highlight duplicate entries within a spreadsheet with many columns. I need to highlight the first column if an entry is returned as duplicate in both column A & B.

Any suggestions?
(I tried the countif formula, but, this just highlighted rows above and below the entries I actually needed).
Thanks in advance.

Hi Samberlina,

Take a look at this link, it may help you. If you need more help let me know

oldchippy

[oldchippy]

Please someone help.
I am trying to highlight duplicate entries within a spreadsheet with many columns. I need to highlight the first column if an entry is returned as duplicate in both column A & B.

Any suggestions?
(I tried the countif formula, but, this just highlighted rows above and below the entries I actually needed).
Thanks in advance.

Hi Samberlina,

Take a look at this link, it may help you. If you need more help let me know

http://www.cpearson.com/excel/duplicat.htm

oldchippy

[Samberlina]

Thanks Oldchippy
I'll give that a try.