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:
- None Found
Comments on this entry are closed.