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

Workflow

Accepted answers

FinnCharlton

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

All comments

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703