Color Code Duplicates

[Lynn]

I want my macro to do the following:

* Compare values within a selected range

* Wherever there is a duplicate value, change the font
color of the entire row to red

Eg If the value "apple" appeared in both A1 and A10, then
row 1 and 10 would have the red font color applied to them

Any suggestions??

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[David McRitchie]

Hi Lynn,
See Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Duplicated Anywhere in Column: Need not be sorted (includes first of duplicates)
Formula is: =COUNTIF($A:$A,$A1)>1

 

[Lynn]

Thanks...this is great!!!

-----Original Message-----
Hi Lynn,
See Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Duplicated Anywhere in Column: Need not be sorted (includes first of duplicates)
Formula is: =COUNTIF($A:$A,$A1)>1


"Lynn" <[email protected]> wrote in

message news:[email protected]...

 

[Lynn]

Thanks Frank...wonderful info!!

-----Original Message-----
Hi
see: http://www.cpearson.com/excel/duplicat.htm#HighlightingDupl
icates

--
Regards
Frank Kabel
Frankfurt, Germany


.