An idea, yes:
may be the conditional format.

If for example the cell is supposed to become red when the value is
null, and the value is null, then it will stay while the condition is
true. Even if you change the "regular" color (it will appear only when
the condition is false)