Excel Tips
Working with Userform Controls »
January 14, 2002
Select / activate the mandatory custom textbox control on a userform.
Counting Cells with Specific Content »
January 11, 2002
How to add the number of cells in a column and then divide into the dollar total of that column.
Duplicates With Conditional Formatting »
January 8, 2002
I have a column of invoice numbers. How can I use Excel to mark the duplicates?
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.