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.
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= 0Amuta5sgdCuMdEY1UnA1UjUwZXBNU EFJYU00UU9EQnc&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.
-----------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment