Thursday, May 24, 2018

yogi_Conditionally Format Arrival Date If Shipping Date Has Arrived Or Passed

Google Spreadsheet   Post  #2450

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-24-2018

question by: UMuildABook
https://productforums.google.com/forum/#!topic/docs/XGupzH6gBac;context-place=mydiscussions
Conditional Formatting: Is Date X days from Today
I have a column of cells with dates that an order needs to arrive in the customer's hands by.  Next to this cell is the number of days it takes to ship to their location.  I would like the arrival date to be highlighted it is less than the number of ship days away from today.