Make a cell red if blank

Options

This seems like it should be a simple task, but I am having challenges getting it to work. I have a need to have a cell turn red if there is no data in it. Once it is populated, the red goes away. I'm sure there is a simple solution but cannot seem to figure it out. Thanks in advance for the help.

Answers

  • M Underbrink
    M Underbrink ✭✭✭✭✭
    Options

    One way you could do it is with a "Helper column" that identifies if the cell is blank with a checkbox. Add a new checkbox column, and apply this formula to the whole column,

    =IF(ISBLANK([Column you want to evaluate]@row),1,0)

    This formula just says, "If the column I am evaluating is blank at this current row, then check the box".

    Then you can use the standard conditional formatting rules to see if the checkbox is checked or not, and format just the one cell that you want to. You can hide the helper column after it is set up. Hopefully this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!