Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |