If you are looking at data over time, you often want to see visually whether numbers have gone up, down or remained static.
Create a third column to show the difference between the two sets of data, in this case =C3 – B3, then on the Home tab, in the Styles group, go to the Conditional Formatting dropdown, go to Icon Sets and select your preferred choice of icons.
This will not at present give you exactly what you want, so now go to the Conditional Formatting dropdown and select Manage Rules. Click Edit Rule and adapt as shown below.
Click OK twice.
You should get the required icons.
If you only want to see the icon and not the difference between the columns, in the Edit Formatting Rule dialog box, check the Show Icon Only box.
Find out more about our Microsoft Excel training in the London area.
Find out more about our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.