Conditional Format IF Blank by 1st of Month

I am trying to create a google sheet to track payments for a team. I want a cell to turn red if a value hasn’t been entered by the 1st of the month. I have 2 other formats already set up to change to green or yellow depending on full payment or partial payment.


Go to Source
Author: Dan