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

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)