Excel - conditional formatting - highlight subtotals

[RachelSK]

I have subtotalled a sales report and need to change the font colour o
the subtotals. I know I should be able to do this with conditiona
formatting but can't get the right criteria - ie: to format each cel
which contains SUBTOTAL in the forumula. Any help would b
appreciated! ... thank

 

[Lady Layla]

Did you subtotal with the Data Subtotal function?

If so, expand or condense so that only the subtotals are showing. Select the
range, hit the F5 key, (goto), select Special, toggle visible cells only, then
format as you see fit


: I have subtotalled a sales report and need to change the font colour of
: the subtotals. I know I should be able to do this with conditional
: formatting but can't get the right criteria - ie: to format each cell
: which contains SUBTOTAL in the forumula. Any help would be
: appreciated! ... thanks
:
:
: ---
: Message posted
:

 

[RachelSK]

Many thanks for the help - worked perfectly