Subtotals Formatting

[Simon Topping]

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

 

[Andy B]

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.

 

[Peo Sjoblom]

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

 

[Simon Topping]

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.




.