Good morning/Evening,
I have a little blank spot...

I am trying to figure out this formula but right now it's not working.

I need when it's 7 days from the delivery date to turn bleu and after the delivery date to turn red.

this is what I have:

Cond. #1: =(O5-TODAY())<7
Cond. #2 =(O5-TODAY())<14

One: Is this correct?

How do i make this in a VB code in Column O (From O5 to O1000)