For developer guidance, see UIApplicationShortcutIconType. Use the following icons in home screen quick action menus. Moves backwards through media playback or slides. Sends or routes an item to another person or location. Use this icon sparingly, as your app should refresh content automatically whenever possible. Always store the current location when pausing, so playback can resume later.īegins or resumes media playback or slides. Moves an item to a new destination, such as a folder. Saves the state and closes the current view, or exits edit mode.įast-forwards through media playback or slides. Takes a photo or video, or shows the Photo Library.Ĭloses the current view or ends edit mode without saving changes. Shows a modal view containing share extensions, action extensions, and tasks, such as Copy, Favorite, or Find, that are useful in the current context. You can also use a fixed space element to provide padding between navigation and toolbar icons. For example, Calendar uses “Today,” “Calendars,” and “Inbox” in the toolbar. If we would prefer that green represents the negative changes and red the positive, we could return to the dialog box and click the Reverse Icon Order checkbox.TIP You can use text instead of icons to represent items in a navigation bar or toolbar. The red icons represent the negative changes (Week 2 is less than Week 1), green icons show the positive changes (Week 2 is more than Week 1), and yellow icons show the times when there was no change between the weeks. The conditional formatting icons have been applied to column C: To close the dialog box and apply the conditional formatting, click OK. There is also an option to change the icon style.
Since the values are there simply to facilitate the conditional formatting, there is no reason for users to see them. This will remove the values (0, 1, 2) and show only the icons. In the second line (the yellow arrow), change the Type to Number and the Value to 1.īefore closing the dialog box, we want to click the check box to Show Icon Only. To change the values, in the first line (the green arrow), change the Type to Number and the Value to 2. From the drop-down list, choose an icon set. In the bottom half of the dialog box, we see the options for Value and Type of comparison.īefore making other changes, we need to choose our Icon Style. We want to use the 3 Arrows (Colored) icons to compare numbers. The default setting is to compare percentages with the 3 Traffic Lights (unrimmed) icons. The New Formatting Rule dialog box appears. From the drop-down menu, click Icon Sets, then click More Rules…. On the Home tab, in the Styles Group, click the Conditional Formatting button. To apply conditional formatting to the values in column C, if necessary, select the values in column C. The result, “0”, should appear in cell C2.Ĭopy the IF function to the rest of the cells in column C: In cell C2, type the nested IF function: =IF(A2>B2, 0, IF(A2 We will compare the two weeks to see if there is a negative or positive change, or no change at all. As you can see, the worksheet includes data for two different weeks. This conditional formatting can be accomplished by combining an icon set with an IF statement. If column A is less than column B, a second icon would appear or if columns A and B are equal, a third icon would be displayed. What if you would like to compare two columns of data and use conditional formatting to give users a visual representation of the comparison? For example, if column A is greater than column B, a particular icon would appear.