Microsoft Excel – using icon sets to compare two sets of figures

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.

Conditional formatting dialog box

Click OK twice.

You should get the required icons.

icon sets

 

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.

 

Advertisements

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s