Timestamp

[Guest]

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?

 

[Tom Ogilvy]

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