Suppose you have a report that shows the sales changes from month to month.
You wish to add green arrows to the numbers when the sales increase over the previous month and red arrow when the sales drop. This can be achieved with conditional formatting in Excel. Here is how it is done.
First select the range that you want to format conditionally. In our example above, choose C3:C13.
Go to the Home tab and select conditional formatting (for Excel 2007 - 2016). Conditional Formatting is grouped within Style.
In the dropdown list, choose Manage Rules.
In the pop-up window, select New Rule.
Follow the following steps in the next pop-up window.
When you have completed the steps, you will get the same setting as shown in the picture below:
The 3 arrows (Coloured) icon set is used, but the conditional formatting rule is defined so that only the green up arrow (positive values) or the red down arrow (negative numbers) can appear. No arrow is shown when the variance is 0 (0<=0 and >=0 at the same time).
Click OK. After that you will see a dialog like below.
Click OK. The arrows are now displayed next to the numbers in C3:C13.