No need for code - a simple conditional formatting will do. (I colored the row for expired invoice, but you can change the formatting for row at will.)

Attached Files

Invoice.xlsx (10.2 KB, 13 views)