Pinterest Pixel

Highlight Cell Rules based on text labels

Bryan
Pivot Tables in Excel are one of the most powerful features within Microsoft Excel that allows you to analyze more than 1 million rows of data with just a few mouse clicks.
Highlight Cell Rules based on text labels | MyExcelOnline Highlight Cell Rules based on text labels | MyExcelOnline

You can use conditional formatting with Excel Pivot Tables to highlight cell rules based on text labels. Let me show you how easy this is with the help of examples.

 

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

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


Example 1:

This is our current Pivot Table setup. We want to highlight all of the Q1 text in our Row Labels.

Highlight Cell Rules based on text labels

STEP 1: Highlight all the quarter text by clicking above the cell

Highlight Cell Rules based on text labels

STEP 2: Go to Home > Conditional Formatting > Highlight Cells Rules > Text that Contains

Highlight Cell Rules based on text labels

STEP 3: Type in Q1 and select OK. You can select any color that you wish.

Highlight Cell Rules based on text labels

The Q1 text is now highlighted! You can do the same for Column Labels as well

Highlight Cell Rules based on text labels

 

Example 2:

In this example, we want to highlight all quarters except Q4 in red.

STEP 1: Highlight all the quarter text by clicking above the cell

Highlight Cell Rules based on text labels

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

Highlight Cell Rules based on text labels

STEP 3: In the New Formatting Rule dialog box, select Specific Text from the first dropdown.

Highlight Cell Rules based on text labels

STEP 4: Select not containing from the second dropdown.

Highlight Cell Rules based on text labels

STEP 5: Type Q4 in the space shown below.

Highlight Cell Rules based on text labels

STEP 6: Click on the Format… button.

Highlight Cell Rules based on text labels

STEP 7: In the Format Cell dialog box, select the red color.

Highlight Cell Rules based on text labels

STEP 8: Click OK.

Highlight Cell Rules based on text labels

This is what the data will look like:

Highlight Cell Rules based on text labels

All quarters except Q4 have been highlighted in red!

 

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 text 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 Cell Rules based on date labels

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