| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Valitaion Input message | Excel Worksheet Functions | |||
| Data Validation Input Message | Excel Worksheet Functions | |||
| DataValidationInput message | Excel Worksheet Functions | |||
| Input message on data validation field | Excel Discussion (Misc queries) | |||
| How can I put more data in the Excel input message? | Excel Discussion (Misc queries) | |||
Hybrid Mode
