Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data consistency
I think this ought to be easy, but have failed to come up with any
ideas. I have adjacent columns entitled "OK" and "Failure reason". OK entries can have data validation to by Yes or No Failure reason should be empty for OK = Yes Failure reason should not be empty for OK = No I could construct a VBA function to enforce such constraints, but am looking for a solution without VBA. I would prefer a solution which does not use auxiliary columns. Happy 2015 to all readers of microsoft.public.excel.worksheet.functions. -- Walter Briscoe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a new line, without destroying the consistency of the formu | Excel Worksheet Functions | |||
Cell value consistency/macro problem. | Excel Programming | |||
Cell value consistency for all sheets/Macro problem. | Excel Programming | |||
Improve consistency in how Excel and Word 2003 close. | Excel Discussion (Misc queries) | |||
how can I change the size of each cell consistency? | Excel Programming |