How do I create a Data Validation formula for Column C? If a person tries to enter a number in Column C when an "X" is in a cell in Column B, would like a pop up box to open that says "Miles Not Allowed". Would prefer not to have to create a VBA formula. Also, would I need two different formulas for Column C if a person enters a capital "X" or a lower case "x" in Column B?
A B C Day Vacation Miles Mon X Tues X Wed 250 Thurs 50 Fri 20
Bookmarks