I HAVE A SPREADSHEET THAT I NEED TO CREATE A REMINDER WHEN SOMETHING HAS A
DUE DATE. CAN THIS BE POSSIBLE IN EXCEL? HELP PLEASE.
You can create a formula in the cell to be monitored that shows the
original date, but that will change to ALERT a set number of days
prior to the current date. For instance, if your target date is Sept
9 and you want to alert on Sept 4 your formula to type in the
monitored cell would be:
=IF(DATEVALUE("9/9/08")-5>TODAY(),"9/9/08","ALERT 9/9/08").
Using the Format menu/ Conditional Format you can format that cell to
change color of font or background at the same time it changes to
ALERT., The CF is: "cell value" "is equal to" ="ALERT 9/9/08"
You type the date into the formula at three places and the CF
formula. The cell will read 9/9/08. in regurlar font color. On
September 4 the cell will change to ALERT 9/9/08 in red type, or
whatever font or background color you want.
ed
=
n the cell to be monitored (I presume it has a date in it) use Format/
Conditional Formating with "cell value" "greater than" =TODAY()-5.
When "today" is less than 5 days away from the monitored cell's date
either the font or bakground will change to your selected color. You
can also put the foloiwng formula in the monitored cell (instead of
the date 9/1/2008) =IF(9/1/2008 +5<TODAY(),9/1/2008,"ALERT-9/1/2008")