Conditional Formatting
I want cells that need to be filled in with values to be highlighted. Like, if A2 and B2 contain a value, highlight C2. Only problem is that C2 has a formula so it's not technically "blank". And I want the formatting to go away once the formula has been overwritten.
The formula is there because if someone indicates "Y" in B2, then the value in C2 gets copied into C3.
Comments
-
If I understand you correctly, I think you will need to dedicate a column to help format the cell you want to highlight. For example, create a column next to the Name column (or anywhere else) and enter a formula that will enter the value "Yes" if C1 has a particular value (or is non-blank) AND if C2 has a particular value (or is non-blank) AND Name is not blank. Then set up a conditional formatting rule that will cause the Name column to be highlighted if the new column has a value of "Yes". Since conditional formatting only looks at one column the new column is needed to look at three columns before deciding what to do. After that it can highlight any combination of cells in that row. Even if the Name cell has a formula in it as long as its value is blank (""), it will still work.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K 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
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives