I am trying to include colors for Sub-Totals and Grand Totals and keeping remaining data as white. Is it possible? Below is the screen shot of what I am trying to achieve. Here the base data is has no colors.
You can play around with the custom diverging colors. Below is a good start. I don't have time to see it through at the moment but can look more at it again when I get some time tonight. Good luck.
Have your tried Total and Grand Total shading options?
Retrieving data ...