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)