Hi, I've searched previous posts as I know I saw the answer but can't find
it now and forgot to print it last time.

I'm inputting a number of part numbers (600 of them) in column A and need to
identify duplicates
as I enter them (on the fly).
Conditional formatting?

What I'd like is if I input a previously entered part number, any and all
occurrences of previous entries
of that part number to highlight so I stop double entries.

Please, not a macro as I'm not into macros yet.

I'm using Excel 2010 and also need the solution to also work on my other
machine using the 2007 version.

TIA.

Mario explained :
Hi, I've searched previous posts as I know I saw the answer but can't find it
now and forgot to print it last time.

I'm inputting a number of part numbers (600 of them) in column A and need to
identify duplicates
as I enter them (on the fly).
Conditional formatting?

What I'd like is if I input a previously entered part number, any and all
occurrences of previous entries
of that part number to highlight so I stop double entries.

Please, not a macro as I'm not into macros yet.

I'm using Excel 2010 and also need the solution to also work on my other
machine using the 2007 version.

TIA.

Step1: Select ColumnA.
Step2: Open the CF dialog and enter the following formula:
=COUNTIF($A:$A,$A1)1
Step3: Set formatting to use shading OR bold, red font

This will flag the dupe AND its original entry.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

"GS" wrote in message
...
Mario explained :
Hi, I've searched previous posts as I know I saw the answer but can't
find it now and forgot to print it last time.

I'm inputting a number of part numbers (600 of them) in column A and need
to identify duplicates
as I enter them (on the fly).
Conditional formatting?

What I'd like is if I input a previously entered part number, any and all
occurrences of previous entries
of that part number to highlight so I stop double entries.

Please, not a macro as I'm not into macros yet.

I'm using Excel 2010 and also need the solution to also work on my other
machine using the 2007 version.

TIA.

Step1: Select ColumnA.
Step2: Open the CF dialog and enter the following formula:
=COUNTIF($A:$A,$A1)1
Step3: Set formatting to use shading OR bold, red font

This will flag the dupe AND its original entry.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


You are amazing, thank you very much Gary, very fast reply!

on 2/25/2011, Mario supposed :
"GS" wrote in message
...
Mario explained :
Hi, I've searched previous posts as I know I saw the answer but can't find
it now and forgot to print it last time.

I'm inputting a number of part numbers (600 of them) in column A and need
to identify duplicates
as I enter them (on the fly).
Conditional formatting?

What I'd like is if I input a previously entered part number, any and all
occurrences of previous entries
of that part number to highlight so I stop double entries.

Please, not a macro as I'm not into macros yet.

I'm using Excel 2010 and also need the solution to also work on my other
machine using the 2007 version.

TIA.

Step1: Select ColumnA.
Step2: Open the CF dialog and enter the following formula:
=COUNTIF($A:$A,$A1)1
Step3: Set formatting to use shading OR bold, red font

This will flag the dupe AND its original entry.

-- Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


You are amazing, thank you very much Gary, very fast reply!

You're welcome! Glad to be of help...!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc