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?