Thursday, January 30, 2014

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   Jan-29-2014
post by Teenie (!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.

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.