Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Date Query

I have a spreadsheet where we input a date when we had first communication
with a potential parent/student. I want the cell to change colors when 10
days have past with no contact. In other words I want to be "alerted" when
we did not follow up with a potential client. Please explain like you are
talking to a second grader because I am a novice user, but I can get it done
if given good directions.

Many thanks!
T
 
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
Query Latest Date Mack Neff Excel Discussion (Misc queries) 1 April 26th 07 07:42 PM
Date query? Harley Excel Discussion (Misc queries) 2 May 11th 06 11:31 AM
How do I query a future date? Ralph 47 Excel Worksheet Functions 0 January 31st 06 06:25 PM
How do I enter a date range ie -7 from current date in MS QUERY notsmartenough Excel Discussion (Misc queries) 1 November 11th 05 10:17 PM
MS Query Date Format scos00 Excel Discussion (Misc queries) 0 October 21st 05 04:58 PM


All times are GMT +1. The time now is 08:00 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"