Up and down arrows in excel conditional formatting

#Up and down arrows in excel conditional formatting how to
#Up and down arrows in excel conditional formatting code

This formula checks if values in the B column are less than 60 days from the current date (for example, suppose today's date is ). After all the cells specified under Applies to are evaluated with this first rule, the second rule is tested. If the formula for any cell in column B evaluates to True, its corresponding cell in column A (for example, A5 corresponds to B5, A11 corresponds to B11), is then formatted with a red background color. This formula tests the cells in column B (cells B2:B15). The formula for this rule is =B2 up and down arrows in excel conditional formatting

We then want this to change to red if C1 contains a Thumbs Down.Д¬lick on cell C1 and from the Home ribbon, click Conditional Formatting, New Rule, Use a formula to determine which cells to format (this step is covered in more detail in this earlier post).ДЄnd click on the Format button to change the font colour to red. We can do this using Conditional Formatting.ДЇirst of all, change the font colour in cell C1 to green (again, either from th Home ribbon or Format Cells). If you need a refresher on the IF function, take a look at this earlier post.ДЄll we need to do now is change its colour. This formula will return the Thumbs Up character if A1 is greater than or equal to B1, and the Thumbs Down character, if it is not. So, if in any particular cell, we change the font to Wingdings (either by right-clicking and using the format cells dialog box, or by selecting the Wingdings font from the drop-down on the Home ribbon),ДЇor our purposes, set the font in cell C1 to Wingdings and type the following formula into cell C1,

#Up and down arrows in excel conditional formatting code

We can refer to any character by its character code using the CHAR function. OK, now cancel this screen, as we are going to insert these symbols in a different way вЂ“ now we know what we want. Click on the Thumbs Down and you will see that this has a character code of 68. This is the character code of this symbol. In this case it says вЂњWingdings: 67вЂќ, so the number to note is 67. Click on it and note the number at the bottom left after the name of the font. If we select the Wingdings font from the drop-down at the top, you can see there is a Thumbs Up symbol there. We can discover what symbols are available in different fonts by selecting Symbol from the Insert ribbon (this is on the far right of the standard Insert ribbon). Either way, we want to make it obvious at a glance that A1 being higher than B1 is a good thing, and A1 being less than B1 is a bad thing.ДЄ green thumbs up, or a red thumbs down, in cell C1, should make this pretty clear вЂ“ so how do we do it?ДЇirst of all, where do we get the Thumbs Up and Thumbs Down symbols from? A1 might be this monthвЂ™s sales, for example, and B1 might be budgeted sales, or last monthвЂ™s sales. Say we have an actual figure in cell A1 and a comparison in cell B1.

#Up and down arrows in excel conditional formatting how to

Once you know how to do this you can replace these with arrows or some other symbols and make the colours whatever you want them to be. In this post, I will show you how to automatically show a green thumbs up or a red thumbs down next to the variance (depending on whether it is good or bad). This week, I want to show you a neat little trick for doing something a little more visually interesting than just using brackets to distinguish between positive and negative variances.