rsdunphy

Posts: n/a

need to show when date is past due

I need to highlite a cell that has a date and is over due 365 days or more
from todays date. Having trouble with conditioonal formatting

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
flag date within a cell after 15 days have past?	SAUDIA	Excel Worksheet Functions	2	August 19th 05 04:33 PM
Is there a function to show future date	taxmom	Excel Worksheet Functions	2	March 4th 05 09:23 PM
How do I format the date to show mm/dd NOT m/dd?	smags	Excel Worksheet Functions	1	January 25th 05 07:39 PM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	2	November 12th 04 03:20 AM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	1	November 11th 04 10:28 PM

All times are GMT +1. The time now is 03:46 AM.

About Us

"It's about Microsoft Excel"