Conditional Formatting on sheet level & row

Katrina · 09/15/22

是很有帮助的可以做到条件formatting for the entire sheet or by a row rather than column by column. It becomes very tedious to enter the same formatting over many columns.

Adrian Mandile CHESS · 09/01/22

It would be great to be able to multi-select "If [this column]..." columns in Conditional Formatting, so that we don't have to clone and duplicate the same formatting for many columns with the same condition.

For example, I have a number of currency-type columns and I'd like them to display in red font if they are less than zero. Do do this currently, I would need to clone the same conditional format many times for each individual column!

Alternatively, this could be achieved with adding an "OR" option, similar to the "AND" option.

Nik Fuentes · 09/16/22

I was under the impression Conditional Formatting already applied to every row that meets its conditions. I also know there's an Entire Row option so you don't have to check off every column.

Do you mean that you'd like the ability to apply a conditional format to every row in one column? [eg: if [row Count]# is Odd then apply this format to Column2]

I think I'm on board, but I might be misunderstanding. Could you provide an example?

Katrina · 09/16/22

I'd like to highlight all of the percentages over 100, but that would include the top row, which does not need to be highlighted. To exclude this row, I had to add another column and exclude that from conditional formatting.

Nik Fuentes · 09/16/22

ahh, I see.

yep, that's a pain and a half to set up.

Sam L · 12/05/22

I have 16 columns of data and I have to set 5 rules for each column. This causes me to have to create 80 rules which was time consuming

Stefan · 02/08/23

Did you ever do a sheet which needed many (e.g. 30 or more) conditional formats?

Currently it’s a tedious nightmare to create them and again, when changes are required.

I request a substantial overhaul of this functionality with use at scale in mind.

Paula Grahame · 04/04/23

I would love to see the conditional formatting feature to be updated to format an entire sheet at once.

I.E: "If this symbol is anywhere on my sheet, apply this formatting to the cell (or row)"

I primarily work in column based sheets with sometimes in excess of 100 columns - each of which have 2 or 3 formatting rules to apply. The process is tedious in a singular column format. Being able to conditionally format an entire sheet at once based on the data in the cell would be a game changer with what can be done on large column based sheets.

Suzanne Raphael · 04/13/23

I have wished for this feature more times than I can remember over many, many years. My latest use case was wishing to highlight any cell that includes the phrase "USAGE NOTE." FYI, I'm in software QA and project management, FWIW.

Ray Lindstrom · 04/26/23

I'm currently in Conditional Formatting hell where I'm applying the same conditional formatting across many columns. I have 5 rules for each column. I create them for one, and then keep cloning and updating settings. It would be great to be able to apply to multiple columns, or the entire sheet, at once.

svenu · 05/02/23

Hi Team,

Currently, a conditional formatting rule applies to the whole sheet. Please add a feature to be able to select a range, similar toApplies toin MS-Excel:

问候

Sowmya

JennS_ · 05/17/23

Please add this feature. There is a serious need for this! I am currently having to manually create formats for 67 columns in a sheet x 3 conditions per cell. This should be an easy update. C'mon smartsheet.

Paula Grahame · 05/24/23

I'm currently in Conditional Formatting hell where I'm applying the same conditional formatting across many columns. I have 5 rules for each column. I create them for one, and then keep cloning and updating settings. It would be great to be able to apply to multiple columns, or the entire sheet, at once.<\/p>","bodyRaw":"[{\"insert\":\"I'm currently in Conditional Formatting hell where I'm applying the same conditional formatting across many columns. I have 5 rules for each column. I create them for one, and then keep cloning and updating settings. It would be great to be able to apply to multiple columns, or the entire sheet, at once.\\n\"}]","format":"rich","dateInserted":"2023-04-26T21:05:20+00:00","insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-08-21T19:46:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373469#Comment_373469","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/373469#Comment_373469

Ugghhhh Same! I have to build 3 or 4 conditional formatting rules for almost 100 columns. Its maddening. And SO easy to mess up.

Full sheet formatting would literally save my work sanity.

Erin Kim · 06/07/23

We need this. I am in a conditional formatting nightmare.

Stu Haney · 06/07/23

Excel handles this much better. Seems like achieving a similar level of capability would not be too hard to do in Smartsheet. cloning formatting for each column can't be the answer! Help!

Scott McQuat · 07/13/23

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

Sign in to submit new ideas and vote

Conditional Formatting on sheet level & row

On Wishlist·Last Updated05/24/23

Comments

Categories