Sign in to submit new ideas and vote
Get Started

Template / Themes for Conditional Formatting

I would love to be able to be able to apply a conditional formatting template to any sheet I wished - much like a design theme in Office 365. And - if I change a rule, it would change it for all the sheets using that template. Can you imagine? How wonderful!

22
22 votes

Idea Submitted · Last Updated

Comments

  • This would be insanely helpful. I am about to have to recreate the same set of 6 rules 13 times over because of this...

  • Annaleah Morrow
    Annaleah Morrow ✭✭✭✭✭

    Absolutely would love this feature!

  • This is a great idea! Also, I would like to be able to change the color options (similar to dashboards).

  • Hello, I use a lot of conditional formatting logics across multiple similar sheets. As we make incremental changes, I often have to completely tear out individual conditionals and then rebuild them. If there are two changes/sheet and we have 15 sheets, I'm suddenly deleting 30 changes, which requires finding the old conditional in the long list, carefully deleting it, modifying the column type, then rebuilding the logic. It would be great if I could make the change once then "copy/paste" the relevant formatting rules to all the new spreadsheets.