I currently have the following set up on an excel spreadsheet



A B C D E
F
1 DATE NAME INVOICE AMOUNT TERM DUE DATE
2
=SUM(A2+F2)
3
4

Is there a formula I can use so that once the due date has passed the cell
(F2) turns red