Pinterest Pixel

Conditional Format a Cell´s Value

A great way to highlight values within your data set, Excel Table or Pivot Table is to... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Conditional Format a Cell´s Value | MyExcelOnline Conditional Format a Cell´s Value | MyExcelOnline

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 workbookCond-Format-Cell-Value.xlsx

 

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

 

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

 

See also  Boost Your Data Analysis with Pivot Tables: Understanding Image and Data Types

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

If you like this Excel tip, please share it
Conditional Format a Cell´s Value | MyExcelOnline Conditional Format a Cell´s Value | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...