Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Validation
I need help in trying on what I think is a validation issue. I'm
trying to get excel to prompt the user to enter information in cell B1 if cell A1 contains data. What would be there formula? Thanks for the help. -JD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Validation
Not being 100% sure of what you are trying to accomplish, this would be one
way of doing what you are looking for. Place this formula in cell B1 =IF(A10,"Please enter value","") As soon as someone typed something in B1, this formula would be overwritten. " wrote: I need help in trying on what I think is a validation issue. I'm trying to get excel to prompt the user to enter information in cell B1 if cell A1 contains data. What would be there formula? Thanks for the help. -JD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Cell Validation | Excel Discussion (Misc queries) | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
Cell Validation. | Excel Worksheet Functions |