FORMAT RULES - CONDITION Hello and thanks in...

(Andrea Sala) #1


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) #2

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) #3

@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) #4

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

(Andrea Sala) #5

@Aleksi_Alkio Thank you anyway. Translate