close
Is there a way to format the subtotal lines that are created when using data,
subtotal and I need to add a line under the new subtotals?
You could use conditional formatting and look for total in the cell, such as
a formula like
=ISNUMBER(FIND(quot;Totalquot;,A1))
and format with underline.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Kathiequot; gt; wrote in message
...
gt; Is there a way to format the subtotal lines that are created when using
data,
gt; subtotal and I need to add a line under the new subtotals?
全站熱搜
留言列表
