Posted to microsoft.public.excel.programming
|
|
Color Code Duplicates
Hi
see: http://www.cpearson.com/excel/duplic...tingDuplicates
--
Regards
Frank Kabel
Frankfurt, Germany
Lynn wrote:
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??
|