On Thu, 2005-09-08 at 12:28, G. Roderick Singleton wrote: > On Thu, 2005-09-08 at 10:12 -0500, Irv Cobb wrote: > > Not sure if I can describe this... > > > > I have a list of song titles that we use in our church. I presently have > > them in an Impress spreadsheet like this: > > > > |date of last use|title| > > > > This way I can keep track of when the song was last used and not use it > > too often. > > > > However, some songs should be used more frequently than others (think > > 1-5, 1=heavy use, 5=light use). > > > > |date of last use|title|use number| > > > > I would like to program the spreadsheet so that it tells me, based on > > the current date, date of last use, and use number, which songs are > > available and which ones have been used recently. > > > > So the calculation needs to do something like this: > > > > A. Get today's date. > > B. Get date of last use. > > C. "Subtract" B from A. > > D. Determine date of next allowable use based on B and "use number". > > E. Compare D with C to determine if song is available or not. > > > > I _think_ I can figure out how to do all of the above. However, > > > > F. Apply red background to date of last use cell if the song is not > > available. > > > > |date of last use|title|use number| > > ^^^^^red background > > > > G. Apply white background to date of last use cell if the song is available. > > > > |date of last use|title|use number| > > ^^^^^white background > > > > Can this be done in a formula? I know it can with a macro, but I have > > little experience with them. Can a formula call a macro? Can this be > > done at all? > > > > All help is deeply appreciated. > > > > Spreadsheets are nice but what you describe is really a database > application. May I suggest that you investigate using a database. Doing > so would make queries such as yours a snap.
I did something similar using Style Catalog to set the background colors. You could create one called "Available" with a white background and one called "NotAvailable" with a red background. Now use the stylist to establish the criteria you need on one of the cells. Use Paste Special to copy only the Format info from this cell to the other cells. Good Luck! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
