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….



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



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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Sort by Largest or Smallest With Excel Pivot Table... There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. The cool thing with Excel Pivot Tables, is it allows me to sort virtually anywhere!Let us start off with this Excel Pivot Table showing the Sum of SALES for...
Filter a Pivot Table by Dates There are an array of different Date filters in a Pivot Table.  You can filter by a particular date range, for example: by this week, next month, next quarter, next year, last year, year to date and the list goes on and on.  This is useful if you want to see what invoices are due...
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...
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 ReplayBONUS VIDEO:   Consolidate Multiple Sheets & Excel TablesIn this training you are going to learn the following:C...