0

I am trying to work out a formula for the below specific Critia.

If cell is blank, colour in yellow if date is 2 days away, colour in red if date has 1 day over.

I am trying to build a traffic light system to alert when a follow date is approaching (Yellow) and when it had surpassed (RED)

Improve this question
2
  • Have you tried conditional formatting? More specificity and what you have tried would help us help you.
    – Allen J
    Commented Jun 19, 2023 at 0:26
  • As asked conditional formatting might be an easy solution for you. I'm going to show a possibility in an answer.
    – BradR
    Commented Jun 19, 2023 at 18:23

1 Answer 1

Reset to default
0

As suggested the screen cap below might give you some ideas enter image description here

Improve this answer

You must log in to answer this question.

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