Friday, December 8, 2017

yogi_Conditionally Format Based On Number Of Days To Ship

Google Spreadsheet   Post  #2313

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-05-2017
How to conditional format dates while referencing another column within the sheet? Help!

I need to create a conditional formatting request for a column (column J) to turn RED if the date of another column (column F) is GREATER THAN 48 hours from the current date and yellow if GREATER THAN 24 hours from the current date.

I need to know if there is an easy way to do this in sheets or what is the formula I should be using. Please help me.