Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
xjustmex said ...How do I write this formula in Google Spreadsheets.....
I have five cells each with a different color text in the cell:
A1: Red A2: Blue A3: Green A4: Yellow A5: Black A6: Done!
I have another cell B1 that is a date field where someone would enter a specific date.
I would like a cell C1 that would look at the date entered in B1 and show 'Red" for first day that was entered in the B1. As day 2 comes, I would like C1 to say Blue, then day 3 comes and would like C1 to say Green, and so one until it has ended at A6 showing "Done!" and stopping there.
-------------------------------------------------------------
No comments:
Post a Comment