I can't seem to figure out the formula for the conditional formatting rule to achieve this. Are you able to assist? When the delivery date is greater than or equal to The existing date and there is no number inside the Bill column, the formula returns one, otherwise It https://mamabee.com/