LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default date tracking

This is a good overview of CF:
http://www.contextures.com/xlcondformat03.html

This is quite good too:
http://www.xldynamic.com/source/xld.CF.html

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dennis Tucker" wrote:

As part of the "client" entries, do you enter the date the client was
entered? This would be the key in doing this task.

In a cell on the worksheet you could enter the formula for today's date
like this =TODAY().

Then use the conditional formatting to do the rest.

See sample attached.


Dennis

"ggmanmd" wrote in message
...
I am entering clients into a 2007 Excel spreadsheet. How do I make the
entry
turn color when 14 days have passed?
Gene


 
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
Tracking Date Changes lee Excel Discussion (Misc queries) 5 November 2nd 06 11:43 PM
Tracking Change Date TJ Excel Worksheet Functions 6 March 16th 06 09:34 PM
Can this even be done? Tracking Date / Time Elapsed scd New Users to Excel 6 February 3rd 06 07:44 PM
Date Tracking TB New Users to Excel 5 January 30th 05 02:01 AM
Tracking by date Les B Excel Programming 1 November 26th 04 08:45 AM


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