PC Review


Reply
Thread Tools Rate Thread

Conditional formatting based on category

 
 
=?Utf-8?B?U2NvdHQgQnVjaGVy?=
Guest
Posts: n/a
 
      22nd Mar 2006
I am making a series of bar charts that use the same categories (i.e. school
name). The bar for each school needs to have a unique color, which will
remain the same in each chart. Also, the order in which the schools are
listed may vary from chart to chart. I assume a macro could be constructed
to perform this type of conditional formating? Any assistance would be
appreciated. Thanks.


 
Reply With Quote
 
 
 
 
=?Utf-8?B?Sm9obg==?=
Guest
Posts: n/a
 
      22nd Mar 2006
This site helped me...
http://peltiertech.com/Excel/Charts/...nalChart1.html

"Scott Bucher" wrote:

> I am making a series of bar charts that use the same categories (i.e. school
> name). The bar for each school needs to have a unique color, which will
> remain the same in each chart. Also, the order in which the schools are
> listed may vary from chart to chart. I assume a macro could be constructed
> to perform this type of conditional formating? Any assistance would be
> appreciated. Thanks.
>
>

 
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
Conditional Formatting Based of Cells Based on Data Entry in anoth Jim Microsoft Excel Misc 3 11th Nov 2008 11:52 PM
conditional Formatting based on cell formatting Totom Microsoft Excel Worksheet Functions 1 20th Jan 2007 02:02 PM
conditional Formatting based on cell formatting Totom Microsoft Excel Worksheet Functions 0 15th Jan 2007 04:35 PM
Conditional formatting based on formatting =?Utf-8?B?VGhlUm9vaw==?= Microsoft Excel Programming 4 1st Nov 2006 02:50 PM
Conditional Formatting Based on If and Or =?Utf-8?B?bHV2dGhhdm9ka2E=?= Microsoft Excel Misc 5 10th Aug 2006 10:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:33 AM.