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

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" <(E-Mail Removed)> wrote in message
> news:A0AF7886-AFFE-49B5-B5AE-(E-Mail Removed)...
> > I am entering clients into a 2007 Excel spreadsheet. How do I make the
> > entry
> > turn color when 14 days have passed?
> > Gene
>