Problems with conditional formatting

Hi,

I am trying to apply conditional formatting to a cell if it is blank. The issue I am having is that the cells I want to apply this to have a formula in them (=IF(Name16 <> "XXX", "N/A", ""). The conditional formatting doesn't pick up the "" as being blank. Have tried a few workarounds but haven't found a solution that works. Any ideas?

Find more posts tagged with

Conditional Formatting

Comments

Andrée Starå

Hi,

A possible workaround could be to change the "" to something like "Blank" and then have the conditional formatting check for that and change the text color to the same as the background, and that would almost hide the information.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ajingham

Hi Andree,

That worked well. Thanks.

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Published Sheet - Users Unable to add Attachments
I have a sheet for which I've provided a publish link to many unlicensed users. They use the sheet to attach files to rows. This has been working as expected for multiple years previously, but today, we've discovered it will not allow them to attach files to rows and they're met with the message "This action has been…
WorkApps Attachments Disabled
Has anyone seen this in WorkApps? Anyone know what's going on?
Will Table view eventually totally replace Grid view?
Is it in Smartsheet's roadmap to stop adding functionality to grid view and only add new features and functionality to table view? Is the long-term plan to make grid view obsolete?