Problems with conditional formatting

ajingham

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?

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