set a yearly alert for information in cells
 

Help! I need to set up some sort of an alert for a yearly update. How do I
accomplish this in an excel spreadsheet??
Thanks

Hi Tam

depends on what you want ... if you have
..........A...............B.............
1......Item..........Update Date

and you want the relevant update date to turn red when it is more than a
year ago ... then
select from B2 to the end of the column of data and then scroll so that row
2 is at the top of the screen (first line you can see)
choose
format / conditional formatting
choose
formula is
type
=$B2<=today()-365
click the format button, set the background colour (under the patterns tab)
to whatever you want (etc)
click OK twice


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tam" wrote in message
...
Help! I need to set up some sort of an alert for a yearly update. How do
I
accomplish this in an excel spreadsheet??
Thanks