![]() 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
0 Comments
Leave a Reply. |