Copy Conditional Formatting Between Unrelated Tables / Conditional Formatting "Presets"

Conditional formatting is awesome, but after I’ve set up a few complex formulas for my desired formatting, I hate having to manually recreate those same settings in another table that might have similar columns referenced in the formulas, but is a completely unrelated table i.e. it’s not as simple as creating a view of the table that inherits the conditional formatting from the parent table.

I’d love a button in the conditional formatting options panel that lets me “copy” all of the conditional formatting settings for a table, including the formulas, to my clipboard to be “pasted” into / applied to another unrelated table.

This could also be implemented as a “save these formatting settings as a preset” button that lets me create a library of conditional formatting settings that I commonly use.

Keep rockin’ Coda!

2 Likes