Conditional Formatting - One rule on multiple columns

kumarrsushil501

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

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.

jhorvath

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å

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!

Eng Stan

Hi this would be a much needed functionality.

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.

Suzanne Raphael

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

bhouse

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.

Eitan Kaplan

+ Add this feature

Eitan Kaplan

+1, Add this feature

Suzanne Raphael

Seriously? We're still waiting for this? SMH.