I would like to change the background color of subtotal rows in Excel to
highlight the rows. I am using the display subtoals function from the menu.
I'm sure there is a way to do it using conditional formatting, but I haven't
been able to figure it out.

Thanks for your help.