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? |
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? |
All times are GMT +1. The time now is 07:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com