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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives