Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for reminder of data needing review on dates?
I need a formula (if there is one) that will set up a reminder in a cell
without using outlook e.g. if data in certain cells needed reviewing every 3 months, the formula cell will show which data is up for reviewing. Hard to explain really |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for reminder of data needing review on dates?
But shouldn't be hard to do. Use conditional formatting with a formula on
the column of dates. Then, you can have the cell background turn red when they need reviewing. See: http://www.officearticles.com/excel/...ft_ excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "Scorp" wrote in message ... I need a formula (if there is one) that will set up a reminder in a cell without using outlook e.g. if data in certain cells needed reviewing every 3 months, the formula cell will show which data is up for reviewing. Hard to explain really |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) |