Posted by
Andrian in
Excel Features on
01 26th, 2009 |
no responses
Yes, I know conditional formatting is technically not a new Excel feature, having existed in many of the previous versions. However, the conditional formatting in Excel 2007 is definitely not your mother’s conditional formatting. For, in addition to giving you the ability to define formatting when the values in cells meet certain conditions, you can now instantly apply one of many different Data Bars, Color Scales, and Icon Sets to the cell selection merely by clicking the set’s thumbnail in their respective pop-up palettes. When you apply a set of Data Bars to a cell range, the length of each bar in the cell represents its value relative to the others. When you apply a set of Color Scales, each shade of color in the cell represents its value relative to the others. And when you apply one of the Icon Sets, each icon in the cell represents its value relative to the others.
Related Post
