i was a little hasty with the reply saying 'everything is ok'! i'm still
having trouble. the document i'm creating is just a very simple table with
two columbs; one containing site addresses and the other containing a
specific date which indicates when the maintenance on the property expires.
all i need is for the cell to change when the end of maintenance date is
reached. i understand how this would be done if i were using value (through
conditional formatting) but not in relation to date. any help would be much
appreciated.


"MartinW" wrote:

Hi Mike,

Yes on both counts.

To find out more about how Excel handles dates just
type date into the answer wizard in the help file.

Also in the help file you can find out about
conditional formatting.

If you are having trouble sorting that out then post
an example of your data and what you want it to do
and someone here will show you the correct way to
make those functions work for you.

HTH
Martin


"mike" wrote in message
...
I am currently using excel 2003, and i understand that excel is able to
calculate dates by using a coding system. is it possible to set up a sort
of
active document, where by inputted dates that have expired would be
flagged
up in some way? for example; change colour of either the text or the cell
itself?
(if this makes no sense just give us a shout and i'll try and explain
again
haha!)
thanks,
Mike.