I'm trying to set up a sheet where if a date is inputted in Cell A, it would
generate a due date in Cell B, and a date for actual completion would have
to be entered in Cell C.
I'm trying to set it up so that if the Cell C is blank, and it is past the
due date, then the date in Cell B would be in red.
Also, how do you set Cell B up to stay blank (instead of having a date with
the year 1900 in it) if nothing has yet been entered in Cell A?


--
Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/