Is there a way to select multiple columns and apply a single conditional format for multiple columns down the columns?
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...
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | 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.
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.
©2022. All Rights Reserved Smartsheet Inc.