Excel Magic Trick 1202


Conditional Formatting For a Cross Tabulated PivotTable

DESCRIPTION

See how to add Conditional Formatting to a Cross Tabulated PivotTable:
(00:08) Problem Setup
(00:28) Set up PivotTable including Group by Year for Date column and Number Formatting for Units Field
(02:00) Set up Conditional Formatting Hurdle in Cells
(02:40) Add Conditional Formatting to a Cross Tabulated PivotTable

WORKBOOKS




Be the first to comment

Leave a Reply