Conditional formatting for numbers

[SAXON10]

Hi,

Column A1:A10 which contains text and numbers with duplicate entry. How to apply conditional formatting for numbers not text. If cells

contain duplicate numbers then CF indicate red colors.


I am apply the following formula in A1=ISNUMBER(COUNTIF($A1:$A10,$A1))>1 but its not working.

Any help much appreciated.


DATA

[TABLE="width: 64"]
<colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>[TR]
[TD="width: 64, align: right"]4512[/TD]
[/TR]
[TR]
[TD="align: right"]6510[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]6510[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[/TR]
[TR]
[TD="align: right"]2111[/TD]
[/TR]
[TR]
[TD="align: right"]8548[/TD]
[/TR]
[TR]
[TD="align: right"]6547[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]6547[/TD]
[/TR]
[TR]
[TD="align: right"]5587

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Try this Conditional Formatting formula:

[COLOR=#333333]=AND(ISNUMBER($A1),COUNTIF($A$1:$A$10,$A1)>1)[/COLOR]

that will highlight all the duplicates.

If you only want the 2nd, 3rd, etc occurrence of a number highlighted (and not the first one), try:

[COLOR=#333333]=AND(ISNUMBER($A1),COUNTIF($A$1:$A1,$A1)>1)[/COLOR]

 

[SAXON10]

Thank you so much for your help. Both formulas working fine.

 

[Joe4]

You are welcome!