Hello all, I hope you can help me? I want to validate a list entry which was originally selected from a list based on a previous list selection. Chandoo's blog on the subject was great for creating a multi list solution;
http://chandoo.org/wp/2008/11/25/advanced-data-validation-techniques-in-excel-spreadcheats/
I now need a way of knowing if the sub lsit selection is valid when the main list selection is changed. In so doing, users will see if they have correctly selected on a dashboard. I am thinking that a conditional format is the solution but cannot seem to put the formula together to achieve this.
The logic is something like:
If selection B is in group A then do nothing, else highlight entry as invalid
I appreciate any assistance on this. Many thanks
Regards
LeonK
http://chandoo.org/wp/2008/11/25/advanced-data-validation-techniques-in-excel-spreadcheats/
I now need a way of knowing if the sub lsit selection is valid when the main list selection is changed. In so doing, users will see if they have correctly selected on a dashboard. I am thinking that a conditional format is the solution but cannot seem to put the formula together to achieve this.
The logic is something like:
If selection B is in group A then do nothing, else highlight entry as invalid
I appreciate any assistance on this. Many thanks
Regards
LeonK