Create column Rule that applies to every column

[BautistaC888]

Hello,

I need to give every cell that contains a "?" symbol a red background color.
I used the rule contains(Filed1, "?") but i want to apply it to all the columns.
Is there a way?

Thank you.

[flying008]

Hi, @BautistaC888 

Maybe you need set rules for each column as your want.

Contains([_CurrentField_], "?")

***********

Please mark this as the solution if it answers your question, it will help others to find solutions quicker.

[BautistaC888]

I have more than 300 columns. Is there any way to apply the same rule to all of them?
Thank you.

[grazitti_sapna]

Hi @BautistaC888 , In that case what you can do is add the table tool on your canvas and configure it before connecting the input tool by selecting dynamic or Unknown Fields so that way the rule will be applied to all the columns when you will connect table tool with input.

[Qiu · Accepted solution]

@BautistaC888 
Same idea as @grazitti_sapna ,it is a cheating approach. 😁

[flying008]

Hi, @BautistaC888 

As @Qiu and @grazitti_sapna said, you can set the rule to last [Dynamic or Unknown Fields] with cover all columns.