Inside the New Formatting Rule dialog, you checked the Show Icon Only check box, typed 90 in the first icon value input, typed 10 in the second icon value input, and clicked the OK button. Inside the New Formatting Rule dialog in the Format Style drop-down, you selected Icon Sets. In the Conditional Formatting menu, you clicked the New Rule. In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. Change the values so the green circle icon (the first icon) will be applied if the cell value is >= 90 percent and the yellow circle icon (the second icon) will be applied if the cell value is =10 percent. Apply the default icon set Three traffic lights (unrimmed) icon set, but show only the icon, not the cell value. TERMS IN THIS SET (33) Create and apply a new conditional formatting rule for the selected cells D2:D15. inside the insert slicer dialog you checked the data check box then clicked ok +11 more terms inside the sort dialog you clicked the ok button use the quick analysis tool to apply the data bars conditional formatting option to the selected cells you clicked the quick analysis tool button, clicked data bars button add slicers to filter the data in this table by date in the design ribbon tab in the tools ribbon group, you clicked the insert slicer button.
inside the sort dialog in the order drop-down you selected largest to smallest. inside the sort dialoging the sort by drop-down you selected cost. you clicked coffee button sort this data by values in the cost column so the most expensive items are listed first in the data ribbon tab in the sort and filter ribbon group you clicked the sort button. inside the insert slicer dialog you checked the category check box, clicked the ok button. TERMS IN THIS SET (15) use a slicer to filter the detain this table to show only rows where the category value is coffee in the design ribbon tab in the tools ribbon group you clicked the insert slicer button.