I need to have multiple data validation rules in a single cell. I've just watched a bunch of tutorials with examples but nothing that fits exactly what I am trying to accomplish. So, I've tried to create my own custom data validation formula...but nothing is working!
Here's an explanation of what I need:
If D52 equals "Small", I need the number the user enters in D55 to be greater than or equal to 220
If D52 equals "Large", I need the number the user enters in D55 to be greater than or equal to 330
So, if "Small" is entered in cell D52, I need an error message to appear if they then enter a number less than 220 in cell D55. At the same time, I need an error message to appear if "Large" is entered in cell D52 and then they enter a number less than 330 in cell D55.
What custom data validation formula can I use in cell D55?
Thank you.
Bookmarks