Hi ken

one option is to conditionally format for values over the largest number in
your dataset ... as long as all the subtotals will be greater than that
number
given the following data
............A................B.................... ..C.
1......Month.......Region.................Sales
2......Jan............North.................50000
3......Feb...........North.................55000
4......Jan...........South...................35000
5......Jan.......... South...................40000

before you subtotal - select all your rows, from row 1
and choose format / conditional formatting
choose
formula is
type
=$C170000
select a format / okay & okay
now subtotal

Cheers
JulieD

"Ken Peterson" <Ken wrote in message
...
I would like to change the background color of subtotal rows in Excel to
highlight the rows. I am using the display subtoals function from the
menu.
I'm sure there is a way to do it using conditional formatting, but I
haven't
been able to figure it out.

Thanks for your help.