Conditional Formatting on Sheet and Row Level

Scott McQuat

There are feature requests for this going back to 2020. Why is this taking so long.

Audra

This option would be extremely helpful. It's so tedious to set up now when you have to set up a format for each column even though you're looking to set up the same condition for multiple columns across the sheet. It would be so much easier to be able to say if there are blanks in all these columns make make that cell this color.

KMeyer

I agree with all the comments that point to the need for a better and more scalable approach to this.

Evan I

Allow conditional formatting to work like it does in excel where i can just select the columns/rows that I want to apply conditional formatting for and then set up the rules. The current method of setting it up by column is very challenging for large sheets with multiple columns and different conditional formatting.

Additionally, allow the conditional formatting from Excel to be imported in to SmartSheet.

Kevin Harrison

I would very much like to see this much requested feature implemented too.

Here I am this evening creating a Training Matrix for 18 staff with 18 columns (staff names) with 120 Training aspects on the rows and 4 levels of competency for each cell

So at the moment, instead of 4 rules to give a cell value or 1,2,3 or 4 a different colour I will be faced with 18 x 4 rules = 72 rules - which I don't think I can face doing!

I'd like to see Conditional Formatting being much more flexible please

Thank you

Paula Grahame

I'm commenting to boost the bejezus out of this idea.

For 5 years now the single most frustrating element of the SS platform for me is the lack of full sheet formatting. I will die on this mountain.

We work with some sheets that have the max of 400 columns. All of which have 3 or 4 levels of formatting that need to be applied.

Anyone wanna take a guess on how many days it takes to apply 1200 conditional formatting rules without missing a single one, or messing any up? My sanity is SEVERELY tested on those days.

Being able to say "If this symbol is anywhere on my sheet, do this" is all I would ever need. Even simply being able to toggle in the formatting rules between individual columns or "Apply to full sheet" would be an insanely helpful enhancement.

IrisT

I'd like to boost this post as I'm currently facing a 35x35 dependency grid formatting exercise with each 3 different formats. I was hoping to find a simple solution here but unfortunately I found this post :) ... so I might continue to test my sanity in building the column formats knowing that I'm not alone! If there is a a better way to push this into the development queue please let me know. Thanks, Iris

Ray Lindstrom

Everybody who reads this thread and agrees on needing this functionality should go to the original post in the thread and up-vote it. The more votes it gets, the more weight it's given when the Smartsheet development planning occurs.

Caz Taylor

Please can we have a way to apply formatting to multiple columns at the same time (or more quickly and easier than having to do each one individually when it is the same rule being applied).

David Dolch

I would like to bump this requests as well.

I have sheets where I have a need to highlight the entire column based on the value in each row. In specific, we have Week Ending columns, with the week ending date in Row 1.

I want to highlight an entire column when the value in Row 1 matches the current week ending.

This has come up multiple times, and I can never find a solution other than to tell my users "Smartsheet cannot do that".

While we are on the subject of row and columns not having the same treatment. Why can we freeze columns, but cannot freeze rows. Again my solution is to say "Smartsheet cannot do that"

hjan11

Similar to excel, allow conditional formatting for a single cell that does not apply to the entire column.

Imran Akhthar

Dear Smartsheet team,

We have been waiting for this basic feature available in other tools (creating conditional formatting) for a series of Columns.

This idea was provided in the year 2021, we are now in 2024, yet we don't see this feature. We can see Smartsheet as a powerful tool, if we can fill this gap/feature.

Please can I get a response to this Idea

Erik Jensen

Just making a note here to wish and pray that this gets implemented asap. Cloning and making dozens of conditional formatting rules for every column is KILLING ME. Thanks!

Caroline Elliott

Having this feature available would save so much time and effort. I currently get put off using conditional formatting because I don't have the time to do the same thing over and over again and then have to redo it all if we decide to rename the columns.

Jamie Koch

I would love to have the ability to add conditional formatting to an entire sheet or multiple columns at once. I agree with everything mentioned above. I have sheets with a TON of rules that are exactly the same thing over and over. Even with the cloning ability, it's time consuming and tedious to set these up.