Conditional Formatting - One rule on multiple columns



  • Is there a way to select multiple columns and apply a single conditional format for multiple columns down the columns?

  • Laura Miller
    Laura Miller ✭✭✭✭✭✭

    I will submit a product request but also want to echo this need. I need to have the same conditional formatting for ~15 rows where a cell is highlighted red if 'XL' is present, orange if 'L' is present, etc. Right now, I need to create 3 conditional formats per column x 15. That's....not efficient or sustainable. Conditional formatting should be able to cloned across columns - this seems like a fairly basic feature and something Excel does SO much better.

  • I was curious if there are any updates on this. I have a conditional formatting rule I need to clone across 15 columns, twice (2 different conditions). I don't really want to have 30 rules for one function...

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @jhorvath

    I hope you're well and safe!

    Unfortunately, it's not possible yet, but it's still an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    I hope that helps!

    Be safe and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi this would be a much needed functionality.

  • Tammy Luther
    Tammy Luther ✭✭✭✭✭

    I echo the need to have this function. I too am building (and have built) sheets using the conditional formatting the clone function just is to cumbersome. Its just easier to build a new rule each time. Have 18 columns and growing and need to set 3 color codes to highlight cell for a monthly metrics and if they are meeting, below, or way below (green, yellow, red) for their achievement that month. I see this thread started quite some time ago, but have not seen any updates coming through. Can someone give us an update on whether this submittal has been considered and /or is on deck for development. For efficiency purposes, which Smartsheets promotes, this would be a great win for a number of users.

  • Please and me to this bandwagon. This seems like kind of a no-brainer feature, and one that I need desperately.