I am familiar with the standard Data Validation within Excel but wondered if there was a way of using conditional validation? i.e. if the entry in column x changes then Data Validation for column y changes to a different set of options?
i would think the 'if' function would do this for you and you can specify results or cell colour.johnny.
Does click here help?
Thanks VoG - that link was the perfect answer
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.