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

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