I have 7 cells in a column. In each cell in the range, I want the only
choice for entry to be TRUE. (If the statement isn't TRUE they will leave
blank.) I also want to specify Data Validation Criteria and generate an
error message so that if a user enters TRUE in more than 1 of the cells in
the range, an error message will be generated telling the user they can only
have True in only 1 of the 7 cells in the range. Can this be done and if so,
how?
--
J