Okay I see that Excel 2010 offers this Data validation. Which almost works for me. But I need it to go one more step. I need to apply like a If statement to it.
What I'm trying to do is Say Column A = XYZ then Column C only allow a Number 1-1000.
Any ideas on how to make this happen?