Hello all,

I am looking for some help with my google doc (I have attached an excel version). I am trying to have the cells with dates in them to turn yellow with the date is 30 days away or less. Also, when that cell turns from white to yellow, an email is sent with some sort of alert letting me know what cell changed color or whatever.

Is this even possible? I have little experience with Javascripting but I would imagine some would have to be used here because I know with GoogleDocs you can't conditional format off another cells value.

Thank you very much for your help. It is much appreciated.


JGoogleDoc Help.xlsx