help with formating subtotal ...

[sokevin]

Hi,

when i use the subtotal button under "tools" i want the subtotal line
to be Highlighted in yellow and be in bold.


is there a quick way of doing this??

thanks

 

[Bob Phillips]

You could use conditional formatting and check the adjacent cell for having
the word Total in it, that is a condition of Formula Is, a formula of (or
with adjusted cells) =ISNUMBER(FIND("Total",A1)), and format as required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
one idea:
1. Select your columns with the data befor creating the subtotals (lets
say column A + B)
2. goto 'Format - conditional format'
3. enter the following formula
=ISNUMBER(FIND("Total",$A1))
and choose your format (you may have to change the searchstring 'Total'
(I'm using the German version of Excel and do not know whcih text is
produced by Excel for Subtotals...)
4. Create your subtotals

 

[Bob Phillips]

It is "Total" and "Grand Total"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)