I have a spreadsheet that contains a few lists: phone extensions, employee numbers, open jobs, cell phone numbers. Periodically, I would update the external data tables (employee numbers and jobs are linked to the accounting system), and save the spreadsheet as a picture. That picture became my desktop. I was just a Windows-M from some useful information.
Recently, I added John Walkenbach’s array calendar (found on his general download page).
I needed a way to identify the current date more quickly, so I added some conditional formatting to the range.
A pretty simple formula, but that little blue box makes it a lot easier to read. The problem with identifying “today” is that I have to make sure it’s updated every day, lest I mislead myself. I was going to make a scheduled task that runs in the middle of the night, but it was just too much trouble. The spreadsheet takes about three seconds to update the ext. data and recalculate so I just update it every time I start Excel – meaning I put the file in my XLStart directory. Usually I start Excel once, first thing in the morning.