Data Valdation Input Message
 

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

Data Valdation Input Message
 

Hi

Mark cells E7:E60
DataValidationCustomFormula =AND($B$3="General Expenses,E7<=500)

--
Regards

Roger Govier


"Klee" wrote in message
...
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

Data Valdation Input Message
 

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(E7500,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.

"Klee" wrote:

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

Data Valdation Input Message
 

This is perfect, Thanks so much to you both!

"Klee" wrote:

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

Data Valdation Input Message
 

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

"Dom_Ciccone" wrote:

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(E7500,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.

"Klee" wrote:

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

Data Valdation Input Message
 

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?

"Klee" wrote:

This is perfect, Thanks so much to you both!

"Klee" wrote:

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

Data Valdation Input Message
 

"Klee" wrote:

This is perfect, Thanks so much to you both!

"Klee" wrote:

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

Data Valdation Input Message
 

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

--
Regards

Roger Govier


"Klee" wrote in message
...
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?

"Klee" wrote:

This is perfect, Thanks so much to you both!

"Klee" wrote:

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