To validate data entry and show error messages to your users in Excel, you can do a couple of things.
- Use traditional Data Validation (go to Data » Validation).
- Use event handlers in VBA.
Continue Reading: Another take on Data Validation »
Another take on Data Validation
January 15, 2010 by · 
A simple formula trick to visualize your errors
November 3, 2008 by · Here's a neat trick I use to make spotting worksheet errors very simple.
Wrap your formula in an IF statement that returns the letter "J" if True, or the letter "L" if False, and change the cell's font to Wingdings.
Continue Reading: A simple formula trick to visualize your errors »
Monitoring a range for changes
October 28, 2008 by · A co-worker of mine has a workbook with an inventory list in column D. He wants a way to highlight low inventory quantities, when the inventory for any particular item falls below a certain amount. At first I thought about conditional formatting, for example:
Continue Reading: Monitoring a range for changes »
Quickly Clear Conditional Formatting
April 2, 2008 by · Here is a simple sub that deletes conditional formatting from a selection. The code does some prelim checking to see that it is actually acting on a range, and it mimics Excel's usual behavior (like a good VBA procedure should, if I may say so) by acting on the entire worksheet if you only select a single cell. However I recommend just selecting the range before you run the code.
Continue Reading: Quickly Clear Conditional Formatting »
Follow Me