Posted to microsoft.public.excel.newusers

external usenet poster

Posts: 3

Tracking Dates For Future Occurrences

Can this be done? I want to track a yearly review. I would like the date,
once entered - say 6/1/2009, to conditionally format to change yellow 30 days
before, then red 15 days before, and then to stay red until the date is
updated again for say 6/1/2010. Can this be done? I am new to all this,
thanks..

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
finding # of occurrences of information between two dates	JPLong	Excel Worksheet Functions	3	December 7th 07 06:36 PM
Tracking the Trend of Occurrences	bmac	Excel Discussion (Misc queries)	3	August 3rd 07 05:02 AM
future dates	kevrgallagher	Excel Worksheet Functions	2	July 14th 05 05:36 PM
future dates	kevrgallagher	Excel Worksheet Functions	4	July 12th 05 03:47 PM
Formatting dates in the future	Compass Rose	Excel Worksheet Functions	3	January 17th 05 10:39 PM

All times are GMT +1. The time now is 02:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us