Conditional Formatting Excel 2013. Selecting the desired cells from the home tab click the conditional formatting command. On the home tab in the style group click the arrow next to conditional formatting and then click top bottom rules.
Selecting the desired cells from the home tab click the conditional formatting command. On the home tab click the conditional formatting button on the toolbar and then select new rule from the menu. Select the command you want such as top 10 items or bottom 10.
A drop down menu will appear.
Enter the values you want to use and then select a format. In this video you ll learn more about conditional formatting in excel 2013. On the home tab click the conditional formatting button on the toolbar and then select new rule from the menu. Enter the values you want to use and then select a format.