FORMAT RULES - CONDITION Hello and thanks in...

[Andrea_Sala]

FORMAT RULES - CONDITION

Hello and thanks in advance for you helpfulness!

I would like to format in blue color all my column set with “Show type” in all my tables. Is it possible?

If not, I was thinking… - I could create 1 format rule for 1 table and then copy the same rule for all the tables.

• Then select all columns in each table. - And write a condition just like " If column type is show --> then blue"

I need your help for the latter part. How can I create that said condition filter?

Is there an expression suitable in order to create a filter based on column types?

Eventually can I filter my columns by their names?

Thanks AS

[Aleksi_Alkio]

You don’t need any formula for the condition rule. You just need to pickup all “Show” columns that you want to format.

[Andrea_Sala]

@Aleksi_Alkio Thanks! Sure, I mean… if possible I would like to avoid to manually pick every each one of them…

I was looking forward to automatize the process: 1) selecting all the column; 2) setting a condition that filter all show type (or all the column with blank header)

[Aleksi_Alkio]

It won’t work because then it will format all columns when the condition rule is TRUE.

[Andrea_Sala]

@Aleksi_Alkio Thank you anyway. Translate