Copy colour format from one sheet to another

ahumne

Hi I want to copy the colour formatting of all the columns in one sheet to around 50 other sheet.

Is there a way to do it? Currently I have to format each sheet individually.

Paste Special is not working for me to copy the format.

 

Thanks,

Adarsh

Andrée Starå

Hi Adarsh,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You could "Save as new" on the sheet, open the new sheet, delete the data but leave the formatting, and then either "Save as New" multiple times or "Save as Template" and use the template multiple times.

Ezra

Brought this up a while ago too...

https://community.smartsheet.com/discussion/time-formats-number-formats-rethinking-ux-and-function

Paul Newcome

I just added to your thread...