Excel Data Entry Validation

  ElephantRhino 18:02 19 May 2006
Locked

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?

  johnnyrocker 19:50 19 May 2006

i would think the 'if' function would do this for you and you can specify results or cell colour.


johnny.

  VoG II 20:41 19 May 2006

Does click here help?

  ElephantRhino 10:21 20 May 2006

Thanks VoG - that link was the perfect answer

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)