Microsoft Office Tutorials and References
In Depth Information
Format Cell Contents Based on Ranking and Average
Specify the criteria you want. Each rule supplies different criteria.
Click OK .
Format Cell Contents Based on Ranking and Average
Select a cell or range you want to conditionally format.
Click the Home tab.
To format with a preset, click the Quick Analysis button ( New ! ), click For-
matting , and then click the Top 10% button.
To format with specified criteria, click the Conditional Formatting button,
and then point to Top/Bottom Rules .
Click the comparison rule you want to apply to conditionally format the selec-
ted data.
Top 10 Items.
Top 10 %.
Bottom 10 Items.
Bottom 10 %.
Above Average.
Below Average.
Search JabSto ::




Custom Search