Conditional Formatting Excel 2013. Select one or more cells in a range table or pivottable report. On the home tab click the conditional formatting button on the toolbar and then select new rule from the menu.
On the home tab in the style group click the arrow next to conditional formatting and then click top bottom rules. Hover the mouse over the desired conditional formatting type then select the. Selecting the desired cells from the home tab click the conditional formatting command.
Objective use conditional formatting to highlight important data visually and identify patterns and trends.
Select the command you want such as top 10 items or bottom 10. Enter the values you want to use and then select a format. Hover the mouse over the desired conditional formatting type then select the. In this video you ll learn more about conditional formatting in excel 2013.
