Conditional Formatting of Table Values

inthenetguy · Apr 1st, 2002, 05:18 PM

Hi everyone--

Just a quick question. Does anyone know if there's anyway to use conditional formatting to change the colors in a table?

I'm trying to create a stacked barchart, and want to know if I can somehow format each bar to a separate color if a certain criteria is met. I can use conditional formatting in the spreadsheet with the data, but all of it is lost when I chart that particular data.

Any ideas? I would think it's GOT to be possible, but I just can't figure out how.

Thanks for your help!
Mike

Damon Ostrander · Apr 1st, 2002, 05:24 PM

Hi Mike,

Yes, the formats of charts (actually chart series or points) is not determined by the formats of the cells being charted. However, it is possible with a bit of VBA code to accomplish "Conditional Formatting" of bar charts, etc. If you would like an example of this respond with your email address and I will send you a spreadsheet with a simple demo. I think you should be able to adapt its methodology to your needs.

inthenetguy · Apr 1st, 2002, 05:50 PM

Thanks. My email address is mclark1@hotmail.com.

Damon Ostrander · Apr 2nd, 2002, 10:54 AM

Okay, on its way.

Apr 1st, 2002, 05:24 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Mike, Yes, the formats of charts (actually chart series or points) is not determined by the formats of the cells being charted. However, it is possible with a bit of VBA code to accomplish "Conditional Formatting" of bar charts, etc. If you would like an example of this respond with your email address and I will send you a spreadsheet with a simple demo. I think you should be able to adapt its methodology to your needs. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Apr 2nd, 2002, 10:54 AM	#4
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Okay, on its way. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 1st, 2002, 05:18 PM	#1
inthenetguy New Member Join Date: Mar 2002 Posts: 6	Hi everyone-- Just a quick question. Does anyone know if there's anyway to use conditional formatting to change the colors in a table? I'm trying to create a stacked barchart, and want to know if I can somehow format each bar to a separate color if a certain criteria is met. I can use conditional formatting in the spreadsheet with the data, but all of it is lost when I chart that particular data. Any ideas? I would think it's GOT to be possible, but I just can't figure out how. Thanks for your help! Mike

Apr 1st, 2002, 05:50 PM	#3
inthenetguy New Member Join Date: Mar 2002 Posts: 6	Thanks. My email address is mclark1@hotmail.com.