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". I would prefer not having 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?
[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]Day[/TD]
[TD]Vacation[/TD]
[TD]Miles[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: center"]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tues[/TD]
[TD="align: center"]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD="align: center"][/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Thurs[/TD]
[TD="align: center"][/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD="align: center"][/TD]
[TD]50[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]Day[/TD]
[TD]Vacation[/TD]
[TD]Miles[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: center"]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tues[/TD]
[TD="align: center"]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD="align: center"][/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Thurs[/TD]
[TD="align: center"][/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD="align: center"][/TD]
[TD]50[/TD]
[/TR]
</tbody>[/TABLE]