Question

steps to use top bottom rules in conditional formatting
​

Answer 1

Answer:

Use Excel 2007's Top/Bottom rules for quick data analysis

Select the cells you want to analyze.

Click the Home tab.

In the Styles group, click Conditional Formatting, then select Top/Bottom Rules.

Click Above Average, then click OK.

Answer 2

Use Excel 2007's Top/Bottom rules for quick data analysis

Select the cells you want to analyze.

Click the Home tab.

In the Styles group, click Conditional Formatting, then select Top/Bottom Rules.

Click Above Average, then click OK.