| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to validate input based upon values in two other cells
I'm trying to pop a warning message (Datavalidiation Stop) or display a text
value in another cell when two conditions exist: Cell D4 is = 0 and cell G4 is having a numberic value entered into it. If Cell D4 is 0 then any number can be entered into G4. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to validate input based upon values in two other cells
Data ValidationAllowCustom
=AND(D40,ISNUMBER(G4)) Gord Dibben MS Excel MVP On Thu, 10 Dec 2009 13:23:01 -0800, JG wrote: I'm trying to pop a warning message (Datavalidiation Stop) or display a text value in another cell when two conditions exist: Cell D4 is = 0 and cell G4 is having a numberic value entered into it. If Cell D4 is 0 then any number can be entered into G4. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validate entry based on another cell value | Excel Discussion (Misc queries) | |||
| Totaling cells based on input value | Excel Discussion (Misc queries) | |||
| Averaging values from a list, based on user input | Excel Worksheet Functions | |||
| Restrict-Filter-Limit-Validate user input in Excel | Excel Discussion (Misc queries) | |||
| validate input of cell A1 to either 8 or 0 based on cell B > 0 | Excel Worksheet Functions | |||
Linear Mode
