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



"Deb Raskob" <Deb wrote in message
...
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