New in Excel 2007 is the ability to apply specialized conditional formatting using colored Data Bars, Color Scales and Icon Sets. Data Bars display a colored data bar relative to the value of the other cells in your range. Color Scales displays two or three gradient color shading relative to the value of the other cells in your range. Excel will color the cells based on the color scale that you select. Icon Sets display an icon in the left of the cell to show visually where the value falls in the range.
As with the other conditional formatting options, click More Rules from the any conditional formatting menu to modify or create your own formatting rules.
To Apply Conditional Formatting using Data Bars
- Select the cell range you wish to format.
- Click the Home tab on the Ribbon.
- Click the Conditional Formatting button on the Home Ribbon and then point to Data Bars.
- Click the colored data bar you want to use.
- Click OK.
- To modify or create your own customizedformatting rules, click More Rules from the list.
Similar Posts:
- Creating Your Own Conditional Formatting Rules in Excel 2007
- Using Conditional Formatting in Excel 2007
- Using Conditional Formatting based on Top/Bottom Values in Excel 2007
- Managing Conditional Formatting in Excel 2007
- Apply Colors and Shading to Cells in Excel 2007
- Apply Cell Styles in Excel 2007
- Locking and Unlocking Cells in an Excel Worksheet
Comments on this entry are closed.