Format Using Icon Sets : Conditional Formatting « Format Style « Microsoft Office Excel 2007 Tutorial





Select a cell or a range. 
           Click the Home tab. 
           Click the Conditional Formatting button. 
           Then point to Icon Sets. 
           Click the colored icon sets you want.
Click the colored icon sets you want.
To create a custom icon sets, click More Rules
To create a custom icon sets, click More Rules
Specify the description. Then click OK.
Specify the description. Then click OK.
Check the result.
Check the result.










3.10.Conditional Formatting
3.10.1.Conditional Formatting: Format Cell Contents Based on ComparisonConditional Formatting: Format Cell Contents Based on Comparison
3.10.2.Conditional Formatting: Format Cell Contents Based on Ranking and AverageConditional Formatting: Format Cell Contents Based on Ranking and Average
3.10.3.Applying Specialized Conditional Formatting Using Data BarsApplying Specialized Conditional Formatting Using Data Bars
3.10.4.Format Using Color ScalesFormat Using Color Scales
3.10.5.Format Using Icon SetsFormat Using Icon Sets
3.10.6.Create Conditional Formatting RulesCreate Conditional Formatting Rules
3.10.7.Clear Conditional Formatting RulesClear Conditional Formatting Rules
3.10.8.Edit Conditional Formatting Rule PrecedenceEdit Conditional Formatting Rule Precedence