yogi_Set Up Conditional Formatting For Items Due inMoreThan3wks Due withIn3wks Due withIn2wks Due lessThan1wk PastDue Over30days

                                         Google Spreadsheet   Post  #1506
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-29-2014
post by Teenie (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/uj02AZP9nus)

Originally created this spreadsheet in Smartsheet. Free trial is over so I have moved to Google.

My spreadsheet has a column for Date Received. This automatically calculates a Due Date of  +30 Days in the next colum over. I need each row to change colors based on the due date.

Here is a link to my spreadsheet https://docs.google.com/spreadsheet/ccc?key=0Amuta5sgdCuMdEY1UnA1UjUwZXBNUEFJYU00UU9EQnc&usp=sharing

At the top of the sheet you will see a color chart of how I would like my rows to change. (As you can see, the rows are already colored as they have moved over that way from Smartsheet) I need all new rows to take on this formatting as well.

I was playing around and trying to figure this out myself to no avail. Please use PO 3592 TA as a sample to play with. 

-----------------------------------------------------------------------------------------------------------------------------------------------------