Formatting Based on Hierarchy level (Dynamically)

[former_member193143]

Hi Every one,

I came across a requirement like as show below.

Where ever the Hierarchy level is 2 in the rows then the entire columns should be colored as yellow...The rows should vary dynamically but the columns are static

Please help me to reach the above requirement.

Regards,

Saida Reddy G

[Former Member]

Hi Saida,

Have you tried to do this with conditional formatting. Check the the selection tab and select levels and then check row headers on the display tab.

[former_member193143]

Hi Mic,

First I want say Thank you for your replies...I need one clarification we are selecting some members on Based on pop up, see the below image as reference.

Based on which criteria the cross tab will give a drop list in Based on selection. I dont understand the how it is picking the members in the dropdown list ... If I know this thing I reach my requirement.

I hope you people got my point.....

regards,

Saida Reddy G