Make a cell red if blank

Craig Robinsono

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.

M Underbrink

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!