I have a worksheet that has 102 departments. Is there anyway that when I
subtotal by department I can have it automatically add color to that line.
For example, could I have it bold and highlight in yellow all subtotalled
lines? I'd also like to add formats around the subtotals such as double
underlines.

On a similar but different way of skinning the cat (I'm not even sure why
you would skin a cat so don't call PETA on me!)...could I do some sort of
macro that would insert a line before the subtotal and add some text to a
specific column of the "subtotal" line and highlight it in a different color
and double underline.