Data Valdation Input Message

K

Klee

I would like to use Data Validation to show a message if a cell (E7:E60) is
more than $500 but I only want it to pop up if a different cell (b3) says
"General Expenses".

If anyone can help it would be much appreciated
Thanks
 
R

Roger Govier

Hi

Mark cells E7:E60
Data>Validation>Custom>Formula =AND($B$3="General Expenses,E7<=500)
 
D

Dom_Ciccone

Highlight the cell E7 and select Data-->Validation

On the Settings tab, in the Allow box choose "Custom"

In the formula box, enter the following:

=IF($B$3="General Expenses",IF(E7>500,FALSE,TRUE),TRUE)

Click OK and then drag fill this down to the rest of the range (through to
E60).

This should work for you.
 
K

Klee

Actually I tried both of these formulas but the pop up comes up regardless
of whether I have a number that's over or under 500. Also if there is no
number in the cell and I click on it the pop up comes up before I type
anything. Any ideas?
Thanks
 
K

Klee

I don't know if I can still get help on this. The formulas above both made
the pop up come up but I only want it to pop up if both of the criteria are
met. At the moment it is popping up as soon as I click on the cell and
regardless of whether my number is over or under $500 or if it says "General
Expenses" or not.

Can anyone help?
 
R

Roger Govier

Hi

I missed a set of quotes from the formula I posted, but I can see it
does not work

Instead use
=IF($B$3="General Expenses",E7<=500,E7<99^99)
Works fine for me.
If B3 = General Expenses, I can only input a value up to 500.
If B3 does not contain General Expenses, I can input any value up to
99^99
 
Top