I don't know much about VBA. If there is anyone who would be able to supply
me with the text to paste in it would be fantastic.

Thanks for the info though Dom, I would have just kept messing around with
data validation until my head exploded

"Dom_Ciccone" wrote:

Ahhhh I see. I'm not aware of any way to do this In Excel itself. If you
are comfortable using VBA the probably the best place to do this would be
attached to the Worksheet_Change() event, checking that the Target cell is
within the range (E7:E60) and if performing your checks there. You could
then flag this to the user as a message box or add a comment to the cell and
display that.

"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!