I am doing a subscription database and I need a code for excel that will show
me when someone's subscription expires. Is there a way to use an 'if
function' and timestamp that will update each time? I have one cell with
their renewal date and another cell that needs to have a certain color and
the words non-current when the renewal date passes. Did I explain this
clearly? Is this possible?

Look at formatting, conditional formatting to color the cell. You can use
an If formula for a message.

=if(today()c2,"Not current","")

where c2 holds the renewal date. Use a formula like =Today()$C2 for
the conditional formatting

See Debra Dalgleish's site for more information on conditional formatting.
http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy



"Starryeyedmusician" wrote in
message ...
I am doing a subscription database and I need a code for excel that will
show
me when someone's subscription expires. Is there a way to use an 'if
function' and timestamp that will update each time? I have one cell with
their renewal date and another cell that needs to have a certain color and
the words non-current when the renewal date passes. Did I explain this
clearly? Is this possible?