Excel Tips
Due Dates With Conditional Formatting »
January 1, 2002
I have a simple spreadsheet with due dates. Is there a way to make the due dates turn green when they are 10 days out, and then red when they are 5 days out?
December 29, 2001
One of my Outlook contacts is incorrectly set to send e-mail to the wrong address. I can change it, but the mail sent to the MyTeam distribution list still goes to the old address.
Dropdown List By Using Validation »
December 25, 2001
Anytime that you have a data validation with dropdowns that are in the frozen pane section of the workbook, Excel 97 would not show the dropdown boxes.
Identify Cells with Formulas »
December 18, 2001
Quickly format cells to indicate which ones have formulas and which have values.
December 12, 2001
I have figured out how to add Hour:Min, but now that I have that total - How do I multiply that times Dollars per hour?
December 11, 2001
If you are responsible for dealing with lots of data in Excel, then this is the best price your company will ever spend for an Excel add-in.
December 7, 2001
How can I get rid of broken links after receiving an e-mailed workbook?