Pinterest Pixel

Show the Difference From Previous Month with Directional Icons

Using a Pivot Table you can show the variance from your previous month’s sales very easily… See... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Using a Pivot Table you can show the variance from your previous month’s sales very easily…

See how to Show The Difference From Previous Months With Excel Pivot Tables here

Show the Difference From Previous Month with Directional Icons

Now that we have the Pivot Table report above, we can show the variances per month using an up/down or directional icon suing Conditional Formatting.

Show the Difference From Previous Month with Directional Icons | MyExcelOnline

Download excel workbookDIFFERENCE-FROM-PREVIOUS-MONTH-WITH-CONDITIONAL-FORMATTING.xlsx

STEP 1: Click on any variance value in the Pivot Table and go to Home > Conditional Formatting > Icon Sets > Directional

Show the Difference From Previous Month with Directional Icons

 

STEP 2: This will bring up the Apply Formatting Rule to dialogue box.  Choose the 3rd option as this will apply the conditional format on all the values except the Subtotals

Show the Difference From Previous Month with Directional Icons

Your Pivot Table will look like this:

Show the Difference From Previous Month with Directional Icons

 

STEP 3: Now we need to make some edits in the Conditional Formatting Rule in order to get the Icons right.

Go to Home > Conditional Formatting > Manage Rules > Edit Rule

 

STEP 4: Inside the Edit Formatting Rule box you need to make the following changes:

Value = 0

Type = Number

“Check” the Show Icon Only box and press OK to confirm the changes:

Show the Difference From Previous Month with Directional Icons

 

STEP 5: In the next screen you will get the Conditional Formatting Rules Manager.  Hit Apply to see the changes and OK to confirm them:

Show the Difference From Previous Month with Directional Icons

Now you have your Pivot Table showing the differences from the previous months with directional icons only!!!

Show the Difference From Previous Month with Directional Icons

 

300x250

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!