Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

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??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Highlight Duplicates with different Color	samangh1 via OfficeKB.com	Excel Discussion (Misc queries)	0	January 22nd 09 08:28 PM
Color duplicates	saman110 via OfficeKB.com	Excel Discussion (Misc queries)	2	October 19th 07 11:26 PM
Need to Color Record in Duplicates	nirod	Excel Worksheet Functions	0	October 24th 06 02:15 PM
zip code and +4 duplicates	darkwood	Excel Discussion (Misc queries)	3	April 7th 06 05:52 PM
Preventing Duplicates using VBA (code)	Jerry McCutchen	Excel Programming	1	July 11th 03 04:51 PM

All times are GMT +1. The time now is 07:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us