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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Lynn" wrote in message ...
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??