In excel, is there a formula that can help highlight a reoccuring monthly due date and once that bill is paid for that month it changes back the color?
Vendor Due Jan Feb Mar Apr
Comcast 27th $100 $100
As shown in the example above, if I have a Comcast bill that is due the 27th of each month, how do I make it so the row highlights once that date arrive and the bill is not paid, but it does that for the entire year, meaning if there isn't a value in the cell that corresponds to the current month, it will highlight on the 27th and each month after on the 27th? So, it is march 27th and the March cell does not have a $100 value indicating that it is paid. and then again for April? etc