Conditional Formatting on Sheet and Row Level

Jamie Koch

Boosting this idea! I know Smartsheet is more column-based than Excel, but I think this would be a helpful feature.

Sylvia Kay

As a user I would like to apply conditional formatting across my entire sheet (or multiple columns), without having to duplicate the condition for each single column.

Example: Whenever Smartsheet finds the term "Fail" in the table, I would like the font color to be red.

I also would like to be able to determine if I want to carry over this formatting into the reports from the sheet.

Thank you, Sylvia Kay

Lisa F.

I am also commenting to "boost the bejezus out of this idea" as @Paula Grahame put it. This is a much needed enhancement that has been discussed for years. Thanks!

Lauren Kleitz

+1 to everything here! Applying a set of rules across multiple columns of data would be so time saving and make my conditional formatting windows less cluttered.

I would also love to be able to apply conditional formatting to values in the Sheet Summary area so that color coding appears in Sheet Summary Reports.

Gary Fairman

I fully agree that the above request would make life alot simpler.

I would also love to see the ability to copy a full set of conditional formatting rules from one sheet to another. Ie I have 30 client sheets which all have very similar logic and every time a formatting change is made it is a nightmare updating it across the multiple sheets.

Paula Grahame

I have commented more times on this post than any other Community post/suggestion.
When I saw this update today - my brain almost exploded.
UPVOTE UPVOTE UPVOTE!!!

I volunteer to be a guinea pig, test subject, collaborator, partner, coffee runner to anyone at Smartsheet willing to get this moving and shaking!

Michelle Choate 2

It becomes so frustrating formatting a sheet with 200 columns with Yes/No as the options, and wanting to turn the cell red if it is No and Green if it is Yes. That takes 400 conditional formatting rules. It is beyond frustrating to not be able to do that with a full sheet rule.

JoshL82

Including things suchs as applying to multiple columns so you don't have to clone the same thing over multiple columns.

It would be nice to apply conditional formats to the task card text itself.

I would like to have row gradiant formatting based on value, so green could be the highest value, red the lowest.

The ability to add some custom formulas/logic in conditional formatting would be a treat as well.

SarahCopleyHirst

It would be useful to be able to reference a range of cells rather than a single column when creating a conditional formatting rule. So, as with Excel you can reference a range of cells within the sheet and where any cells within the range comply with the criteria they adopt the formatting. For example you could reference a range of columns and format all that are before today. This would mean that the user would not have to create multiple duplicate rules for each column.

CarrieLS

I have a sheet with 25 columns with the same dropdown value options. 12 conditional formatting rules per column! Would love to be able to apply the same rule across multiple columns. Have the condition apply to the individual cell instead of a column.

Darren Mullen

@CarrieLS

We have a browser extension that can do this now. It will copy from one sheet to another in addition to copying rules in the same sheet that have the same conditional formatting condition and application columns.

It's a solution available now while Smartsheet works to add this to the core platform :)

https://youtu.be/XjQakCR-7_Q?si=Dnt5U4ISMj7aV_y7