You can try the following
Highlight the range B1 to B20.
Select Menu option Format/Conditional Formatting
Enter the following in the Formula (Select Formula Is option)
=(INDEX($B$1:$B$20,MATCH(TODAY(),$A$1:$A$20))="")
Select an appropriate (warning) format.
What this will do is format the range B1:B20 with the specified format in
case the
exchange rate entry for the current month is missing.

Alok


"amy" wrote in message
...
Thank s Dave.

Just need a function or formula to trigger user by monthly
basic to update the excel spreadsheet.

Your advice is deply appreciated.

-----Original Message-----
Hello.

If you are talking about notification, you can use a
formula with
conditional formatting to "show" when something may be
out of date. Is that
what you are looking for?



wrote in message
...
Hi all,

How are you ?

Need your advise on Excel spreadsheet again.

I have an ammout, let said 12000 (USD) and would like to
divide into 20 months as follows. Before I divided in 20
months, I Have to convert the accounting rate from USD
to
Singapore dollars. Meaning is every I hv to do a
calculation and update in followng excel format. As the
accounting rate will different every month.

May I know is there a notification function in Excel
spreadsheet where the user will be able to set for
triggerring user to update the speadsheet by monthly or
weekly as we like.

Really appeciate you help on this.


Month currency rate actual ammunt in SGP
Dollars
Sep-04 2.5
Oct-04
Nov-04
Dec-04
Jan-05
Feb-05
Mar-05
Apr-05
May-05
Jun-05
Jul-05
Aug-05
Sep-05
Oct-05
Nov-05
Dec-05
Jan-06
Feb-06
Mar-06
Apr-06



.