Highlighting Duplicates

[Matt from AZ]

Is there a way to highlight all the duplicate numbers in a column?

 

[Dave R.]

Surely;

select your range (e.g. a1:a25)

go to formatting>conditional formatting> FORMULA is (not cell value is):
=COUNTIF($A$1:$A$25,A1)>1

then choose format, and select whatever color you want it.

 

[David McRitchie]

Hi Matt,
read about:
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Select the cells you want to be colored
base the formula on the active cell
in this case the columns are absolute so as long as the
active cell is anytwhere on row 1 the formulas will work,
they are checking Column D.
format, conditional formatting

Duplicate identifications (yellowish first among duplicates, greenish for actual duplicates)
formula 1 is: =IF(COUNTIF($D:$D,$D1)>1,COUNTIF($D$1:$D1,$D1)=1)
formula 2 is: =IF(COUNTIF($D:$D,$D1)>1,COUNTIF($D$1:$D1,$D1)>1)