Subtotals Formatting

Hi,

Is it possible to change the formatting of a set of 
subtotals such that they for instance could be displayed 
in red to make them stand out, without having to change 
each individual one?


Cheers

Simon
0
anonymous (74722)
10/31/2003 1:49:54 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
453 Views

Similar Articles

[PageSpeed] 4

Simon

One way is to show the detail you wish to change, then use Edit/Go
to/Special/Visible cells. This will select all visible cells only, which you
can then format as you wish.

Andy.

"Simon Topping" <anonymous@discussions.microsoft.com> wrote in message
news:099501c39fb5$dce555a0$a601280a@phx.gbl...
> Hi,
>
> Is it possible to change the formatting of a set of
> subtotals such that they for instance could be displayed
> in red to make them stand out, without having to change
> each individual one?
>
>
> Cheers
>
> Simon


0
andy2763 (218)
10/31/2003 1:56:44 PM
Another would be to use conditional formatting, assume the text part of the
subtotal starts in B2
and the amounts in C2, select the amount range with C2 as the active cell,
do format>conditional formatting,
select formula is and use

=ISNUMBER(FIND("Total",B2))

click the format button and choose a red font, click OK twice

-- 

Regards,

Peo Sjoblom


"Andy B" <andy@removethisbit.dawsons.co.uk> wrote in message
news:%2324f4a7nDHA.2592@TK2MSFTNGP10.phx.gbl...
> Simon
>
> One way is to show the detail you wish to change, then use Edit/Go
> to/Special/Visible cells. This will select all visible cells only, which
you
> can then format as you wish.
>
> Andy.
>
> "Simon Topping" <anonymous@discussions.microsoft.com> wrote in message
> news:099501c39fb5$dce555a0$a601280a@phx.gbl...
> > Hi,
> >
> > Is it possible to change the formatting of a set of
> > subtotals such that they for instance could be displayed
> > in red to make them stand out, without having to change
> > each individual one?
> >
> >
> > Cheers
> >
> > Simon
>
>


0
terre08 (1112)
10/31/2003 2:10:58 PM
Andy, that's superb. Cheers

Simon 

>-----Original Message-----
>Simon
>
>One way is to show the detail you wish to change, then 
use Edit/Go
>to/Special/Visible cells. This will select all visible 
cells only, which you
>can then format as you wish.
>
>Andy.
>
>"Simon Topping" <anonymous@discussions.microsoft.com> 
wrote in message
>news:099501c39fb5$dce555a0$a601280a@phx.gbl...
>> Hi,
>>
>> Is it possible to change the formatting of a set of
>> subtotals such that they for instance could be displayed
>> in red to make them stand out, without having to change
>> each individual one?
>>
>>
>> Cheers
>>
>> Simon
>
>
>.
>
0
anonymous (74722)
10/31/2003 2:13:12 PM
Reply:

Similar Artilces: