We’ll use a conditional formatting rule to highlight values equal to or less than 21. To get started, select the data you want to format in Excel, in this case, that’s C3:F6 and do the following: ...

The conditional format rule adjusts for each region when you use the slicer to filter the PivotTable. Figure I Remove the filter and the rule highlights the greatest value in the PivotTable.

Open Conditional Formatting > Highlight Cells Rules > Greater Than. Instead of typing the number, select the cell, set formatting, and click OK . Now, if your sales target is $60000 for the next ...

If you are interested in creating your own rules for your Excel spreadsheet, then make sure to read How I use conditional formatting to automate my Excel spreadsheets like a pro.