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
On 2002-05-10 09:31, Brian from Maui wrote:
Noir,
Try this conditional formatting
=countif(A:A,a1)>1
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