Wednesday, February 15, 2012

yogi_Color DeadLine Notification Dates In An Adjacent Column


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user qbender said:
Deadline Notification (dates in spreadsheets)
In spreadsheets, is there anyway to set a notification (of any kind) on dates entered in a cell? For example, I've entered 02/15/2012 in a cell and I want to be notified when that date passes. I'm managing the submissions of 50-odd writers and I need an easy way to keep track of their deadlines without having to rewrite everything in a calendar.
------------------------------------
following is a solution to the problem