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

4512
6510
6510
AA
AA
2111
8548
6547
6547
5587

<colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>
</tbody>

 

[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!