Download Excel Workbook
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.
HELPFUL RESOURCE:
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.
