Excel Data Entry Validation

  ElephantRhino 18:02 19 May 06
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 06

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 06

Does click here help?

  ElephantRhino 10:21 20 May 06

Thanks VoG - that link was the perfect answer

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

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…