Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Code Duplicates
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?? |
#2
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?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Code Duplicates
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Duplicates with different Color | Excel Discussion (Misc queries) | |||
Color duplicates | Excel Discussion (Misc queries) | |||
Need to Color Record in Duplicates | Excel Worksheet Functions | |||
zip code and +4 duplicates | Excel Discussion (Misc queries) | |||
Preventing Duplicates using VBA (code) | Excel Programming |