Conditional Format Column : condition possible on ColumnHeader ?

[gaeldevys]

Dear Anders,

I tried to use CF (condition formatting) on all columns, coming from a "Calculation Group", using a condition based on "ColumnHeader". It doesn't seem to work even if the condition is written: a) ColumnHeader()=="YoY%" b) ColumnHeader()=='YoY%'

My aim is to use CF to avoid "add column conditional formatting", which is relative to a context (month) and thus not dynamic when the month is changing, unless you have a trick to let that function 'relative' and not 'absolute'

Thanks in advance for your tips. Best regards

Gael

[AndersAano]

Hi @gaeldevys,

This is something we have been asked before, and we are currently finalizing a new version which will address this issue. A new feature will allow you to specify that you want to treat columns as measures. If you turn that ON, you will be able to right-click the "YoY%" column and add conditional formatting to that.

It would then be applied to all "YoY%"-columns as is if was a measure.

I don't have an exact date for when this is done, but I'll come back as soon as we have the version ready in beta.

Best regards Anders

[AndersAano]

Just to show you what we have done:

With the option turned OFF (which is the case for the current version in production):

With the option turned ON, in the upcoming version:

[gaeldevys]

Dear Anders

It looks nice: looking forward to using it soon. Thanks a lot for your time.