Different Types of Conditional Formatting in Excel 2007
When creating a new formatting rule, several options are available for how you want the formatting to appear. The following list covers the broad categories for these options, but there are also several subcategories within each one.
2-Color Scale – This option allows you to pick two colors, assigning one to the highest value in a selection and the other to the lowest. Values that fall within the minimum and maximum will be assigned a color that is somewhere “between" these two original choices.
3-Color Scale – Similar to the 2-Color Scale, this option allows you to pick one additional color that will be associated with the midpoint of your data range.
Data Bar – Rather than alter the color of an entire cell, the Data Bar option can be chosen if you want to show how each particular value in your list compares to the rest of the collection.
Icon Sets – With this tool, you can choose a set of graphics and have your formatting rule apply a different icon to each value in your list based on the group to which the value belongs. For example, you may choose an Icon Set with four images, and break your data up into quarters.
As this series progresses, we will take a more detailed look at each of these options.