lol Me either. Thanks Debra for giving me a much easier way of doing it!

"Roger Govier" wrote:

Hi Deb

I'm ashamed to say that in 12 years of using Excel, I have never noticed
that Style dropdown.

--
Regards

Roger Govier


"Debra Dalgleish" wrote in message
...
You can use an Error message, instead of an Input message.
In the data validation dialog box, on the Error Alert tab, create a
message.
From the Style dropdown, choose either Information or Warning.
Users will see the message, but will be able to enter any amount.

Klee wrote:
Yes, I did enter the formula correctly but it's a question that's
worth asking. I have several different formulas in E8,E9 ect to see
what works. Yours is great except for the error. I want people to be
able to enter an amount in the cell regardless of the amount. I just
want the pop up to let them know that they need to fill out a
different form when the amount is over $500. Sorry that I didn't
explain that better earlier.

Any suggestions?


"Dom_Ciccone" wrote:


I've just created a new workbook and entered the validation in cell
E7 as

=IF($B$3="General Expenses",IF(E7500,FALSE,TRUE),TRUE)

This is the same formula I posted earlier. Make sure "Ignore Blank"
is checked. This formula works fine on mine. Are you sure you
entered it correctly (sorry I know that's a basic question but it
really does work on this machine).

The formula displays an error if B3 contains "General Expenses" and
you attempt to enter a value over 500. If you enter a value equal to
or less than 500 the error message does not appear. If however, cell
B3 does NOT contain the phrase "General Expenses", then the error
message will not appear no matter what value you use in cell E7.

"Klee" wrote:


I tried to get back and reply on my last question but was unable to
so I had to start a new question. I'm trying to use the data
validation to make a pop up come up in a cell (e7) if two criteria
are met. One is if B3="General Expenses" and the other is if e7 is
more than $500.

I got a couple of formulas from my previous question. The problem is
that as soon as you click on the cell the message pops up. This
happens whether the cell is blank or over or under the $500 and
regardless if B3 says "General Expenses" or not.
Is there a way to get the pop up only if the other criteria are met?
Thanks again!



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