HOW TO CHANGE COLOR AUTO OF A CELL IF CELL BLANK

Select etiher the whole column, or just the cells with your formula. Go to
Format-condition format.
Set condition to if cell value = ""
Click format, and pick the red pattern.
--