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

 

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

Conditional Format a Cell“s Value

 

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

 

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

Conditional Format a Cell“s Value

 

See also  Excel Table: Row Calculations

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

Conditional Format a Cell“s Value

Conditional Format a Cell“s Value

 

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

Conditional Format a Cell“s Value

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

Conditional Format a Cell“s Value

 

HELPFUL RESOURCE:

Adding Data Labels To An Excel Chart

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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin