Can I copy a conditional format to other columns

[MikeFrancis1959]

I have a conditional format that if a column value is less than zero it is red and if it is greater than zero it is green. I need to do this on 20 other columns, is there a way to copy the formatting to the other columns or do I need to do it manually?

Thanks,

Mike

[FinnCharlton]

@MikeFrancis1959 are these column rules? One tip is to change the name of all columns (you can do this with dynamic rename). Then apply the column rule to the 'Dynamic and Unknown fields'. You can then get rid of the dynamic rename, and because the names were different before all the columns will be seen as dynamic or unknown, meaning they all get the rule

[MikeFrancis1959]

yes, column rules. So if I change all the column names by using a dynamic rename then I can apply the rule and it will put the conditional format to all the columns and then delete the dynamic rename and the conditional format will stay on all the columns, correct?

Mike

[FinnCharlton · Accepted solution]

@MikeFrancis1959 Yep, you just need to put the column rule on the 'Dynamic Or Unknown Fields' column