Conditional Formatting - One rule on multiple columns
Answers
-
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...
-
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!
Best,
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
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
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.
-
Please add this feature. I just had to delete 732 conditional formats to change the column type and now I have to go back and add all 732 conditional formats back into the sheet.
-
+ Add this feature
-
+1, Add this feature
-
Seriously? We're still waiting for this? SMH.