#1   Report Post  
Old January 1st 15, 10:54 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 279
Default 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

  #2   Report Post  
Old January 1st 15, 06:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2011
Posts: 3,514
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a new line, without destroying the consistency of the formu HPH Excel Worksheet Functions 6 May 28th 09 11:08 AM
Cell value consistency/macro problem. Alden Excel Programming 1 November 25th 07 10:50 PM
Cell value consistency for all sheets/Macro problem. Alden Excel Programming 0 November 25th 07 04:05 PM
Improve consistency in how Excel and Word 2003 close. Florence Moosengale Excel Discussion (Misc queries) 5 November 30th 05 12:25 AM
how can I change the size of each cell consistency? Matthew Louden Excel Programming 1 October 17th 03 03:13 AM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017