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.
iMac Pro review
Illustrator Charles Williams on how to create magazines and book covers
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.