highlight subtotal rows with a fill color

[Deb Raskob]

I want to highlight the subtotal rows with gray fill color so they stand out.
Can this be done without "pasting" the format from one row to the rest

 

[Peo Sjoblom]

Use conditional formatting, select the table except for the headers and use
something like

Formula is


=ISNUMBER(SEARCH("Total",$A2))


where A2 would be the first cell below the header click format, then pattern
and select grey
then click OK twice


--


Regards,


Peo Sjoblom