date tracking
 

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

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