I have of a spreadsheet that I’m working on. I have a few things I want to do with it.
1. If the last date under the used columns are 30 or more days prior to today’s date then I want to change the fill color in the qty cell to green.
2. In the days left column I want to display how many days are left before I can use another certificate. You can only use 1 certificate every 30 days. When I use a certificate I put the date it was used under the used headings. I have an image of the spreadsheet and the actual file here:
http://mikemwa.googlepages.com/excel
How do I go about doing this.
Thanks,
Mike
1. If the last date under the used columns are 30 or more days prior to today’s date then I want to change the fill color in the qty cell to green.
2. In the days left column I want to display how many days are left before I can use another certificate. You can only use 1 certificate every 30 days. When I use a certificate I put the date it was used under the used headings. I have an image of the spreadsheet and the actual file here:
http://mikemwa.googlepages.com/excel
How do I go about doing this.
Thanks,
Mike