In Excel: select a clean data range, choose Insert ▸ PivotTable, place fields into Rows, Columns, Values and Filters, then refresh when the source data changes.
Grand total: 1,250.50
| Region | Sum |
|---|---|
| West | 125.50 |
| East | 1050 |
| South | 75 |
The same thing in your own sheet
Sum · Excel & Sheets
What this does
A pivot table summarizes a flat data table without writing formulas. Rows and Columns define the groups, Values define the numbers to aggregate, and Filters or slicers narrow the view. It works best when the source has one header row, no blank columns, one record per row and consistent data types. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “conditional formatting excel pivot table”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected pivot table change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A sales table has Date, Region, Rep and Revenue columns. Insert a PivotTable, drag Region to Rows and Revenue to Values. Excel returns total revenue by region. Drag Date to Columns and group by Month to turn the same source into a monthly regional summary. Pivot tables are one of the highest-leverage Excel tools for summarizing messy transactional data into totals by customer, region, month, product or owner. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “conditional formatting excel pivot table”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Using a report layout with merged cells or subtotals as the source.
- Forgetting to refresh after source data changes.
- Letting Excel count a numeric field because one source cell contains text.
- Building formulas beside a pivot table without allowing for the pivot size to change.
Frequently asked questions
What is a pivot table?
It is an interactive summary table that groups and aggregates records from a source table.
Why is my pivot table counting instead of summing?
At least one value in the source field is text or blank in a way that makes Excel treat the field as non-numeric.
How do I update a pivot table?
Right-click the pivot table and choose Refresh, or use Data ▸ Refresh All.
Other ways people ask this
On the way here you may have searched this as “excel pivot table conditional formatting”, “excel conditional formatting in pivot table” and “excel conditional formatting on pivot table” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “excel pivot table conditional formatting”, “excel conditional formatting in pivot table”, “excel conditional formatting on pivot table” all point at the one operation explained on this page, which is why they all lead here.