Conditional Formatting on sheet level & row
Options
Katrina
✭✭✭✭
It would be helpful to be able to do conditional 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.
Tags:
Comments
-
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.
-
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?
-
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.
-
ahh, I see.
yep, that's a pain and a half to set up.
-
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
-
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.
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
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.
-
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.
-
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.
-
Hi Team,
Currently, a conditional formatting rule applies to the whole sheet. Please add a feature to be able to select a range, similar to Applies to in MS-Excel:
Regards
Sowmya
Regards
Sowmya Venugopal
CI Analyst II, Niagara Bottling
-
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.
-
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.
-
We need this. I am in a conditional formatting nightmare.
-
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!
-
There are feature requests for this going back to 2020. Why is this taking so long.
