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

Conditional Format a Cell´s Value | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Select a cell in your Pivot Table.

Conditional Format a Cell´s Value | MyExcelOnline

 

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

Conditional Format a Cell´s Value | MyExcelOnline

 

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

Conditional Format a Cell´s Value | MyExcelOnline

 

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

Conditional Format a Cell´s Value | MyExcelOnline

 

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

Conditional Format a Cell´s Value | MyExcelOnline

Conditional Format a Cell´s Value | MyExcelOnline

 

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

Conditional Format a Cell´s Value | MyExcelOnline

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

Conditional Format a Cell´s Value | MyExcelOnline

 

HELPFUL RESOURCE:

728x90

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn