Monday, June 16, 2014

yogi_Conditional Formatting For Dates In Column B - Compared To Reference Date red if within 7days -- yellow if within 14 days -- green if over 14 days

                                         Google Spreadsheet   Post  #1676
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jun-16-2014
post by Lissette Irizarry: (!category-topic/docs/spreadsheets/fFoZZTI91u4)
Conditional Formatting
How can I specify 1-4 weeks vs. entering specific dates? I want to avoid having to update the date field on a weekly basis. Thank you!
I would like for the background of the DUE DATE to automatically change from green (14+ days from due date) to yellow 14 days before due date & from yellow to red 7 days before due date.

B1 should have a red background because it's within 7 days of due date
B2 should have a yellow background because it's with 14 days of due date
B3 should have a green background because it's over 14 days from due date

See attached...I apologize for not being clear. I hope this helps.

Thanks much!
Attachments (1)
Test - Sheet1.pdf
22 KB   View   Download