Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation Y N N/A
HI There, I need to put validation on cells for "Y" "N" or "N/A", but the cell can NOT be blank. The cells are currently all prepoulated with a N. Users will then need to change the N to either Y or N/A, but it can not be blank. I see there is an ignore blank option that can be checked or unchecked within data validation, however it doesnt seem to do much. ie I apply the validation to my cells, but are still able to delte a N and leave a blank. Any ideas...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation Y N N/A
If you uncheck Ignore Blank they will not be able to clear the DV.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Darin Kramer" wrote in message ... HI There, I need to put validation on cells for "Y" "N" or "N/A", but the cell can NOT be blank. The cells are currently all prepoulated with a N. Users will then need to change the N to either Y or N/A, but it can not be blank. I see there is an ignore blank option that can be checked or unchecked within data validation, however it doesnt seem to do much. ie I apply the validation to my cells, but are still able to delte a N and leave a blank. Any ideas...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |