Conditional Formatting applied by Row instead of by Column
Hi everyone,
I'm wondering if there's a way for conditional formatting to be applied across a row, rather than having to enter a new rule for every column.
For example, in the sheet below, is it possible to make a rule as follows: If Engagement Name = Variance, then apply red font to any cell in the entire row that is less than zero.
Right now, it seems like the only option is to create individual rules for every month column. Basically saying: If Engagement Name = Variance and 'Oct/2020' (column name) is less than zero, then apply red font to only that cell.
My end goal: to highlight all negative numbers in the entire sheet with the least amount of conditional formatting rules.
Any help is appreciated!
Best Answer
-
Thanks for the prompt response, @Genevieve P . That's unfortunate to hear, as I'm sure this is a functionality that's been requested by users for years, since it's native and so often used in Excel. I went ahead and submitted a Product Enhancement form. Have a great day!
Answers
-
Currently Smartsheet's Conditional Formatting functionality is a column-by-column set up. This means that you will need to set a rule for each of the columns in your sheet to look down through its values and see if it has less than 0. There isn't a way to set this for a full row or full sheet.
If you have a moment, please fill out this form here to provide your feedback to our Product Team!
Thank you,
Genevieve
-
Thanks for the prompt response, @Genevieve P . That's unfortunate to hear, as I'm sure this is a functionality that's been requested by users for years, since it's native and so often used in Excel. I went ahead and submitted a Product Enhancement form. Have a great day!
-
Want to let everyone know this is an important efficiency item and we need this SOOOONNNNN!!!! asking for three years for this is way too long in the tech world SmartSheet...let's get r done please. (as the old folks say).
-
Also came to this thread looking for the same solution. I submitted a request through the product enhancement form, and hope this gets some traction!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives