Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Is there a formula I can use so that cell F2 turns red once we've
passed the due date.
Click to expand...

Presume col F = due dates and we have in F2: =A2+E2,
F2 copied down to say, F10
(your : =SUM(A2+E2) can simplified to: =A2+E2)

To apply the cond format to the range F2:F10:

Select F2:F10 (F2 active)
Click Format > Conditional Formatting
Under Condition 1, make the settings as:
Formula is: =AND(F2<>0,F2<TODAY())
Click Format button > Patterns tab > Red > Font tab > bold/white >OK
Click OK at the main dialog
 
Back
Top