(C) 2009 - 2014 by Mourad Louha · All rights reserved

The changes to the Conditional Formattings in Excel 2010

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.

Excel 2010 Conditional Formatting

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.

Excel 2010 Conditional Formatting

Excel 2010 Conditional Formatting

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).

Excel 2010 Conditional Formatting

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.

Excel 2010 Conditional Formatting

We didn’t find any changes in the options for the “Color Scales”, however some new icon sets have been added.

Excel 2010 Conditional Formatting

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.

Excel 2010 Conditional Formatting

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:

 

 
Comments

No comments yet.

Leave a Reply