Microsoft Excel - GROUPBY Function Automatic Color Formatting
Learn how to use Conditional Formatting in tandem with the new Excel GROUPBY function to apply dynamic cell formatting to subtotal and grand total rows.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
Previous "GROUPBY Function" video:
• Excel's New GROUPBY Function (w/ Bonus Fea...
01:07 Demonstrating the Dynamic Nature of the GROUPBY Function
01:39 The Artwork Objectives
01:57 Starting with the Data and the GROUPBY Function Results
02:22 Painting the Header Row
02:39 Painting the Grand Total Row
04:14 Painting the Subtotal Rows
05:56 Conditional Formatting Order of Processing Issues
06:52 Customizing Subtotal Headings' Text
08:02 Preventing Rule Conflicts
09:06 Performing the Final Tests