![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |