Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Is there a way to copy a sheet's conditional formatting rules to use on another sheet?


I would like all of my sheets to have consistent formatting, 


  • Lainie Franklin
    Lainie Franklin ✭✭✭✭

    I believe the best way to do this is to have your own template created with the applicable conditional formatting. When you start a new sheet, use that template.


    The templates are especially useful because when creating a new sheet you don't have to remember the order of your columns. When moving/copying cells to other sheets, if they are not in the same order, it causes issues. 



  • JamesR
    JamesR ✭✭✭✭✭✭

    Sue, to add to Lainies comments.


    Templates are great, however if you then change your sheet you need to create a new template.  I use RMB - Save as New, in Advanced options de select what you do not want it  to keep, Or keep all and delete the data out of the new sheet.



This discussion has been closed.