Possibly the easiest way to do this is to apply conditional formatting
that colors the cell red if its value is blank. You could write code
that would check those cells for values, but it is not as
straightforward and would require some type of event (leaving a
particular cell, updating a cell, etc.