Need a warning when a duplicate appears in a column
 

Hello good people!

Anyone who can help me with following problem:

I need warning to pop up when the user of a sheet is trying to put/write the
same letter, number or word in two different cells in a column.

I must mention that the cells in use are already validated, using a list
validation.

Anyone? :)

Best regards
ELFrodo

Need a warning when a duplicate appears in a column
 

You could use Conditional Formatting to color both cells when a duplicate is
entered.

Select A1:A50 and FormatCellsCFFormula is:

=COUNTIF($A$1:$A$50,A1)1

Format to a nice bright red.

To have a warning "pop up" would require VBA code or Data Validation which you
have used already.

If you did use DV you would change the formula to =COUNTIF($A$1:$A$50,A1)=1


Gord Dibben MS Excel MVP


On Sun, 11 Feb 2007 15:41:00 -0800, ElFrodo
wrote:

Hello good people!

Anyone who can help me with following problem:

I need warning to pop up when the user of a sheet is trying to put/write the
same letter, number or word in two different cells in a column.

I must mention that the cells in use are already validated, using a list
validation.

Anyone? :)

Best regards
ELFrodo

Need a warning when a duplicate appears in a column
 

Thanks Gord Dibben.

Think it might work:)

Have a good day!
ElFrodo


"Gord Dibben" wrote:

You could use Conditional Formatting to color both cells when a duplicate is
entered.

Select A1:A50 and FormatCellsCFFormula is:

=COUNTIF($A$1:$A$50,A1)1

Format to a nice bright red.

To have a warning "pop up" would require VBA code or Data Validation which you
have used already.

If you did use DV you would change the formula to =COUNTIF($A$1:$A$50,A1)=1


Gord Dibben MS Excel MVP


On Sun, 11 Feb 2007 15:41:00 -0800, ElFrodo
wrote:

Hello good people!

Anyone who can help me with following problem:

I need warning to pop up when the user of a sheet is trying to put/write the
same letter, number or word in two different cells in a column.

I must mention that the cells in use are already validated, using a list
validation.

Anyone? :)

Best regards
ELFrodo