LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich
 
Posts: n/a
Default Setting notification of dates in Excel

assume the pass date is in row b,,,, you could but the now function in row c
and use conditional formating to hightlight the date when it is less than 2
months away

"Needing help in Guam" wrote:

How do I setup a notification that a date of expiration is 2 months away in a
spreadsheet. I want the spreadsheet to automatically highlight if the person
is about to expire with a qualification date. Is this possible and how do I
achieve this goal?

Thanks for any help!

 
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
Help with Excel Dates [email protected] Excel Discussion (Misc queries) 3 September 12th 05 02:41 PM
how do I link purchase order dates from one excel workbook to ano. LeLe123 Excel Worksheet Functions 1 September 2nd 05 03:55 PM
Excel File in Use Notification Missing?? JoD317 Excel Discussion (Misc queries) 6 April 19th 05 02:33 PM
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. KymY Excel Discussion (Misc queries) 3 February 11th 05 02:28 PM
Setting today's date automatically in Excel. Ezlpo Excel Worksheet Functions 6 February 11th 05 02:27 PM


All times are GMT +1. The time now is 01:51 AM.

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

About Us

"It's about Microsoft Excel"