Highlight a row of Pivot Table data - How?

**bdav1216** · 09-25-2018, 06:56 PM

Is there a way to use conditional formatting to highlight an entire row of pivot data?

See attached pivot:

If any value is GE 10 (as an example), how would I go about highlighting the entire pivot row?

If the pivot table is refreshed (and the rows change), would this formula account for that?

**JeteMc** · 10-01-2018, 10:00 PM

If GE is grand total for a row then highlight the range F4:L8 and use the following formula as a conditional formatting rule: =$L4=10
Let us know if you have any questions.

Highlight a row of Pivot Table data - How?

LinkBack

Thread Tools

Rate This Thread

Display

Highlight a row of Pivot Table data - How?

Re: Highlight a row of Pivot Table data - How?

Thread Information

Users Browsing this Thread

Similar Threads

Table to column problem to create dataset for pivot table [Bloomberg data to pivot table]

Automating Pivot table and pivot chart creation if data table names unknown

highlight pivot table rows under condition

non-VBA way to highlight the Top 3 values per row in a pivot table

Pivot Table: Retain individually highlight cells after update

Highlight rows in pivot table when change in dataset cells value

Need pivot table to automatically highlight subtotal rows

Bookmarks

Bookmarks

Posting Permissions