Some changes and additions were made to the Conditional Formatting dialogs and options. In this article we will briefly present the main points. For doing this, I first created a sheet, entered some values and then choosed the menue “Conditional Formatting” from the “Home” tab. Then I selected “Data Bars” from the submenue.
If you know Excel 2007, you will quickly notice that the choice “Gradient Fill” has been added. This suggests that the dialog for conditional formatting was also changed. And yes, some new options have been added as you can see in the figures below. The first one shows the dialog from Excel 2007, the second one the dialog in Excel 2010.
As you can see, some options for formatting the cells (style, types and values) are new. The default values for the types are now “Automatic” and new options for formatting the bar appearance have been also included; for example for selecting the fill style (solid fill or grandient fill).
I’ve tried a few settings, following picture shows the results. On the right side, I selected a font size of 1px and white as font color.
We didn’t find any changes in the options for the “Color Scales”, however some new icon sets have been added.
The dialog for the Formatting rules was also changed, new options for selecting the icons are available and you can choose icons from different icon sets for specific values. When testing this, this unfortunately not always worked.
Concerning the other options, we have not found changes. And we did not check, if using conditional formats with formulas has new features.
This article has also been published in German and in English on the following sites:
- Excel Ticker Blog, German
- Professional Excel Solutions by Maninweb.de, English
- Professional Excel Solutions by Maninweb.de, German