Subtotals Formatting

  • Thread starter Thread starter Simon Topping
  • Start date Start date
S

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
 
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.
 
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
 
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.




.
Click to expand...
 
Back
Top