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

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.

If the failure reason is one of a list of pre-defined items that are
available when OK = "No" then use a DV list in that col and impliment
CF to 'flag' the cell if not empty when OK = "Yes", perhaps?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion