Pinterest Pixel

Highlight Cell Rules based on date labels

Bryan
Pivot Tables are a great tool for viewing and analyzing data in Excel.

A Pivot Table has a large amount of data that can be much easier read by highlighting the specific values that need to be viewed. One of the most common ways of highlighting values in pivot tables is by using conditional formatting.

Adding conditional formatting to Pivot Tables can brighten up the data and make it easier to analyze and interpret.

Let us see how one can highlight cell rules based on date labels in a pivot table.

 

Download this Excel Workbook and follow the step-by-step tutorial below:

download excel workbookHighlight-Cell-Rules-based-on-date-labels.xlsx


This is our current Pivot Table setup. We want to highlight all of the dates of the current month (July 2021) in our Row Labels.

Highlight Cell Rules based on date labels

 

Example 1:

STEP 1: Highlight all the date labels by clicking above the cell

Highlight Cell Rules based on date labels

STEP 2: Go to Home > Conditional Formatting > Highlight Cells Rules > A Date Occuring

Highlight Cell Rules based on date labels

STEP 3: Select This Month and select OK. You can select any color that you wish.

Highlight Cell Rules based on date labels

The dates for this month are now highlighted! You can do the same for Column Labels as well.

The best part is this is dynamic, if you open this workbook again next month, the highlighted date values will be for the next month instead!

Highlight Cell Rules based on date labels

 

Example 2:

Further elaborating on this, we can even highlight a certain range of dates that we want to focus on. This can be achieved through the following steps:

STEP 1: Highlight all the date labels by clicking above the cell

Highlight Cell Rules based on date labels

STEP 2: Go to Home > Conditional Formatting > Highlight Cells Rules > Between…

Highlight Cell Rules based on date labels

STEP 3:Enter the range of dates that you want to be highlighted and select a style in which you want the cells to be highlighted.

Highlight Cell Rules based on date labels

The dates that lie within this range are now highlighted!

Highlight Cell Rules based on date labels

This is how you can highlight cell rules based on date labels by using conditional formatting in Pivot Table!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it



Highlight Cell Rules based on date labels | MyExcelOnline


Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Highlight 30 Days from Today using Excel Conditional Formatting

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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