Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timestamp
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timestamp
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
timestamp | Excel Worksheet Functions | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp ? | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) |