1

In Excel i need a formula for the following: If the end date on sheet 2 cell A1 is 3 days later than the start date on this sheet cell a2, then the cell must turn red.

Please help!

Improve this question
2
  • 2
    =$A$1-Sheet1!$A$2>3
    – rajeev
    Sep 14, 2017 at 15:47
  • Should be >= to pick up a date that is exactly 3 days later.
    – Bandersnatch
    Sep 15, 2017 at 2:19

1 Answer 1

Reset to default
0

Enter this formula into conditional formating.

=IF(A1<(A2-3),TRUE,FALSE)

Improve this answer
1
  • @rajeev has it right
    – Bandersnatch
    Sep 15, 2017 at 2:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .