Excel 2010 introduces some new icon sets and data bars functionality. Episode 1069 will show you these features.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the to the MrExcel netcast.
While we're continuing our look at the Excel 2010 new features, I want to talk about conditional formatting.
They made some improvements here; let's talk about the icon sets.
So, we choose the row when icon set you'll see that there are now some new icon sets.
They added the star ratings here now whether the stars completely filled in and the kind of the up neutral and down triangle arrow, so those are cool.
Another great improvement that we have is in the data bar, now data bars are basically adding a tiny little bar chart in each cell.
We've had this gradient fill there were six of those before but they've added something new called the solid fill; the solid fill so let's do that conditional formatting, data bars and the solid build.
Now you'll see the solid fill actually kind of covers up the numbers and I'm suspecting that they plan on using this when you go in to manage rules, edit rule and say that we don't want to show the value, show the bar only, click OK and that will prevent the numbers from showing up.
You just get the little bar charts, very cool way to go.
Another thing they added here was dealing with negative numbers, negative numbers always sort of cause some problems in the data bars and we now kind of have an option of how to deal with negative members.
Take a look at that you'll see the positive numbers are showing up in green and the negative numbers are showing up in red and we have options there; if we go to manage rules, and edit the rule, we have control for the negative value in the axis we can change the fill color, we can make it the same color as a positive bar also this interesting one here that if the number is negative they just switch it over to read but make it go left to right.
Let's take a look at that; I'm sure there might be some uses for that at some point, so there you have the red number showing up, you know indicating that it's negative not sure I'm a big fan of that, but you might have a use for it.
So, lots of big improvements there in the conditional formatting both with the icon sets and the data bars whether they are gradient or solid, also the ability now to make those be negative in a different color, very cool improvements to a feature that was introduced back in Excel 2007.
I want to thank you for stopping by.
Tomorrow Mike Grivin and I are going to take a look at the new SPARKLINE functionality, yet another way to do small graphics right inside the cell.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
While we're continuing our look at the Excel 2010 new features, I want to talk about conditional formatting.
They made some improvements here; let's talk about the icon sets.
So, we choose the row when icon set you'll see that there are now some new icon sets.
They added the star ratings here now whether the stars completely filled in and the kind of the up neutral and down triangle arrow, so those are cool.
Another great improvement that we have is in the data bar, now data bars are basically adding a tiny little bar chart in each cell.
We've had this gradient fill there were six of those before but they've added something new called the solid fill; the solid fill so let's do that conditional formatting, data bars and the solid build.
Now you'll see the solid fill actually kind of covers up the numbers and I'm suspecting that they plan on using this when you go in to manage rules, edit rule and say that we don't want to show the value, show the bar only, click OK and that will prevent the numbers from showing up.
You just get the little bar charts, very cool way to go.
Another thing they added here was dealing with negative numbers, negative numbers always sort of cause some problems in the data bars and we now kind of have an option of how to deal with negative members.
Take a look at that you'll see the positive numbers are showing up in green and the negative numbers are showing up in red and we have options there; if we go to manage rules, and edit the rule, we have control for the negative value in the axis we can change the fill color, we can make it the same color as a positive bar also this interesting one here that if the number is negative they just switch it over to read but make it go left to right.
Let's take a look at that; I'm sure there might be some uses for that at some point, so there you have the red number showing up, you know indicating that it's negative not sure I'm a big fan of that, but you might have a use for it.
So, lots of big improvements there in the conditional formatting both with the icon sets and the data bars whether they are gradient or solid, also the ability now to make those be negative in a different color, very cool improvements to a feature that was introduced back in Excel 2007.
I want to thank you for stopping by.
Tomorrow Mike Grivin and I are going to take a look at the new SPARKLINE functionality, yet another way to do small graphics right inside the cell.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
