I can't seem to determine the formula for your conditional formatting rule to attain this. Have you been in a position to assist? When the delivery date is greater than or equal to The existing date and there isn't any number during the Bill column, the formula returns 1, https://mamabee.com/