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.

Find more posts tagged with

Comments

Jim Hook

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Blank rows appearing on the bottom of Report and embedded reports
I have a report that will generally only have about 15 rows on it. I see in other threads that Smartsheet will automatically create enough blank rows to reach 50, or at least 10 blank rows always at the bottom. Even if I delete the blank rows from the Sheet (which has hundreds of data rows), they reappear the next time I…
Automating Quarterly/Annual Reminders
I need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
Set Dashboard as Default Homepage for All Users
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!