If Column1 = X and Column2 = Y...

Hi,

I'd like to add a safeguard into my workbook so that users can't enter incorrect values. The general logic is: "If Cell(n,1) = "X" AND Cell(n,3) = "Y" then Msgbox "Error".

So, for any row, if the first column has X and if the second column has Y, then "Error".

Any ideas?

Thanks!

Maybe:

Please Login or Register  to view this content.