Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scorp
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM


All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"