Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formula

See Mr Excel & excelisfun Conditional Format a Chart:

1) Excel 2010 with an automatic feature
2) Formula Method

Format Columns where quality rating is greater than 97%.

Category:

Education

Tags:

• Excel
• 2007
• 2010
• Mike
• Gel
• Grvin
• Highline
• Community
• College
• Mr
• excelisfun
• Duel
• Conditional
• Format
• Chart
• Columns
• where
• quality
• rating
• is
• greater
• than
• 97%

[MsSven04]

Hi, this is really great! I do have a question though ont he chart above, what if we have 2 sets of data, out of which only one i would like to conditional format (let's say three ranges), how would you go about that? For example, instead of having just Cash, I would like to add Revenue data and Revenue to conditional format in three ranges to show me three different colors based on the categories i want. Is it possible?

[ExcelIsFun]

Just expand the data set. In this video we had two data ranges for one conditional column, so if you had three, make six data ranges. Or if there were only two columns that you needed conditionally formatted, then use four ranges for those and one for the last one.

[zikaonline]

every time I enjoyed watching your videos

Keep going guy

Best regards

[ExcelIsFun]

I am glad that you like it!

[dmr450]

I think the winner is Excel 2010, otherwise it's a 50 50 split.

[ExcelIsFun]

Cool!

[Jency83]

Nice tutorial. However if I add data labes, it shows N/A for the blank bar. Any idea how to sort this out?

[DoreaneRenee]

Hi! will this work in 2003? Yep...my organization is behind the times....however I have had to do all these green and red columns manually for the last year. Thank you!!

[hikusar]

@hikusar never mind, this method allows stacked columns.

[hikusar]

Thanks for this tutorial, is there a way to conditionally format stacked columns?

[ExcelIsFun]

I am glad you liked it!