Microsoft Excel Tips and Tricks
In this video, I demonstrate how to add Conditional Formatting to a PivotTable in Excel. Watch as I go through the steps of inserting a PivotTable, choosing the fields (Brand, Rep, and Invoice Amount), and applying Data Bars with a green gradient fill. I show how to properly format all the cells and avoid applying conditional formatting to subtotals and grand totals. Learn how to tweak and manage your conditional formatting rules effectively. My online Excel training class is available for those who want to dive deeper. Thank you for watching! Have a great day.
Credit Chris Menard