Debra,

What if the cell is empty, what would be the formula for an alert?
Lets say my validation cell is A2, if A1 is empty and some data is
typed in cell A2, I need an alert, is it possible?

Thanks.
Mukesh




"Debra Dalgleish" wrote:

You're welcome! Using data validation, users won't have to enable
macros, if there's no other code in the workbook.

matt ball wrote:
Wow. I didn't think this would work... but it does! This is a very simple
(and effective) solution. Thanks, Debra. -Matt

"Debra Dalgleish" wrote:


Yes, you could do this with data validation:

Select the cell (C3 in this example), and choose DataValidation
For Allow, choose Custom
In the Formula box, enter: =C3<0
On the Error Alert tab, for Style, choose Warning
Enter your error message, and click OK

matt ball wrote:

Is there a way to set up a column that any time a "0" is entered in any cell
in that column then a pop up message will display? Saying something like:
"Are you certain this entry is correct?"

I have very little experience with writing macros, but am otherwise
generally well-versed in Excel. Data validation is quite capable of this
function... I don't think.

Any help would be appreciated.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html