Next, you want to format the subtotal rows so that they adopt a light green fill. Again, carefully review the data to see what conditions you can use to apply the formatting to these rows only.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy ...