PC Review


Reply
Thread Tools Rate Thread

Different colors for different sets duplicate cells

 
 
Robert
Guest
Posts: n/a
 
      14th Oct 2008
Okay...I think I can do this in Excel 2007 with color ranges for conditional
formatting but I'm using Excel 2003 and need help coloring some cells. What
I have, very simply, is a single row of numbers in which duplicates can
arise. I not only want to change the color of the duplicates (which I have
already done with =COUNTIF($A$2:$A$11,A2)>1 used as conditional formatting)
but each different duplicate occurrence I would like to be in a different
color. For example, for the table shown:

170
122
96
72
14
78
69
78
128
122

The numbers 78 and 122 are duplicated in the list. My current formatting
highlights all four of the numbers with a particular color. What I'd like to
have the formatting do is to highlight the occurrences of 78 in a different
color than those of 122.

Is this possible in Excel 2003? Can anyone help?

Thanks, Robert.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do I see duplicate sets in Master Slide View? Sandy Microsoft Powerpoint 0 21st Apr 2009 08:21 PM
Linking a horizontal set of cells to a vertical sets of cells =?Utf-8?B?UnVzc2VsbC1zdGFuZWx5?= Microsoft Excel Charting 2 21st Oct 2005 03:19 PM
How do I delete both sets of duplicate data? =?Utf-8?B?U3VwZXJwcmVjaW9zYQ==?= Microsoft Excel Misc 1 24th Jul 2005 08:56 PM
Duplicate sets of document files rlamar Windows XP Customization 1 20th Dec 2003 06:15 PM
multiple exact duplicate sets of folders? Jack Folliard Microsoft Outlook Discussion 1 8th Dec 2003 02:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:02 PM.