A great way to highlight values within your data set, Excel Table or Pivot Table is to use Conditional Formatting rules.

Formatting cells that contain a specific criteria, for example, greater than X or less than X, is a good way to visualize your results.

When your criteria references a cell, then you can make this conditional format interactive.  So as you manually change the referenced cell´s value, the conditional format gets updated and you can see the live results, as shown below….

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Select a cell in your Pivot Table.

 

STEP 2: Go to Home > Conditional Formatting > New Rule

 

STEP 3: Set Apply Rule to the third option: All cells showing “Sum of SALES” values for “MONTH” and “YEAR”

 

STEP 4: Select a rule type: Format Only Cells That Contain

 

STEP 5: Edit the Rule Description. Go to Cell Value > Greater Than > Select The Cell

 

STEP 6: Select the cell format. Click Format and select a color. Click OK.

Try it out now! The highlight now happens dynamically when you update the value.

Cond Format Cell Value

HELPFUL RESOURCE:

728x90

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

Share on Google+

Google+

Related Posts

Protected: What Else Can Excel Pivot Tables Do?  The Pivot Table Webinar Replay & Xtreme Pivot Table Online Course is Closing its Doors in... Click Here To Watch The Webinar Replay BONUS VIDEO:   Consolidate Multiple Sheets & Excel Tables In this training you are going to learn the following:C...
Different Ways to Filter an Excel Slicer Excel Slicers are the best thing since sliced bread! They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table. There are several ways that you can filter an Exce...
Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...
Fix Column Width in a Pivot Table Each time you Refresh a Pivot Table you will most likely get annoyed at the fact that the column widths that you worked so hard to align - will return back to normal 🙁 Do not fear, Pivot Table Options is here! All you need to do is Right Click in the Pivot Table and choose...