Formatting Attribute Hierarchies
 

Hi,

I'm using Excel 2007 and displaying an Analysis Services cube. I'd like to
know if there is an easy way to differentially format dimensions within an
attribute hierarchy.

Consider an example in which a time hierarchy (Year-Quarter-Month) is
displayed on the columns. I'd like a different background color for subtotals
by each level of aggregation. I can do it manually, bit this gets tedious.
I've looked at the conditional formatting but haven't figured out how to fit
this scenario. Is there an easy way?

Thanks,

John