Is there a cell formatting based on the display of column header 3 to 6?

[Jacky_C]

Hi all,

I am exploring the functionality of cell formatting based on the text of column header 3-6, I noticed there is a conditional formatting ColE1HeaderDisplayText and ColE2HeaderDisplayText, but not sure if the same function could be applied to header 3 -6 as well. Thank you.

[TGG_Alex · Accepted solution]

@Jacky_C 

These settings refer to the Column level nesting.  ColE1 is Level 1 DIM selection and ColE2 is level 2.  Similarly RowE1 refers to the Row Level 1 DIM definition and Member Filter set up.  Note that for Columns, you are limited to 2 levels whereas for Rows, you are limited to 4 levels.

The Column Headers column settings you show influences the Header Text.  Think of these as overrides.  If you Column Level DIM definitions contain V# S# and T# but the order by default is not how you would like to show it or you would rather it include E#, you can accomplish this through this setting up to 6 DIMs.

If your objective is the conditionally format Column 3 to 6 of your CubeView, you can consider using ColName and declare the column name to apply format.  In this way, even if you insert a column in the future, as long as the Column Name remains unchanged, your conditional formatting will apply as expected.

Hope that helps