help with formating subtotal ...

  • Thread starter Thread starter sokevin
  • Start date Start date
S

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 :)
 
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)
 
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
 
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)
 
Back
Top