Hi folks. I'm trying to create a situation where the user would get an error message when they tried to enter numbers in two specific columns in the same row. That is, in row C they can only enter a number ( 1 or 2) into C5, C6 or C7. If they enter a number into two of these cells, I want an error to appear. They would have to stop and correct the error.
I've tried two scenarios with no luck:
1. I've data validation where I did SUM(C5:C7) and hid the answer in C8. I then tried to get a data validation to display an error code when C8 exceed 2. This didn't work.
Any ideas?
Bookmarks