Need to highlight duplicate entries within column A

[Noir]

Column A of my workbook has a series of serial numbers. I would like to be able to either highlight the cell of bold the text when a serial numbers has been entered more than once within column A.

Thanks,
Noir

 

[Brian from Maui]

Noir,

Try this conditional formatting

=countif(A:A,a1)>1

 

[Yogi Anand]

On 2002-05-10 09:25, Noir wrote:
Column A of my workbook has a series of serial numbers. I would like to be able to either highlight the cell of bold the text when a serial numbers has been entered more than once within column A.

Thanks,
Noir

Suppose your values are in cells A2:A11, then use Conditional|Formatting -- put the following formula for cell A2

=COUNTIF($A$2:$A$11,"="&$A2)>1

Hope This Helps!

 

[Yogi Anand]

On 2002-05-10 09:31, Brian from Maui wrote:
Noir,

Try this conditional formatting

=countif(A:A,a1)>1

Hi Brian:

Your formula is short and sweet! and is better than mine.

Regards!

 

[Brian from Maui]

Yogi,

You mean I FINALLY got one right!

Actually I got the formula from this board a while back.

Brian

 

[Yogi Anand]

On 2002-05-10 10:05, Brian from Maui wrote:
Yogi,

You mean I FINALLY got one right!

Actually I got the formula from this board a while back.

Brian

Hi Brian: Now let us not be too modest -- Great Job.

Regards!

 

[Noir]

Thanks guys!

 

[Nimrod]

This message was edited by Nimrod on 2002-05-10 23:24