I have cells C5 to C10 - people can only enter a '1' in each cell
Their sum shows in C11
I want only 2 of the cells (any of them C5,6,7,8,9 OR 10) to have '1' entered in, so the sum in C11 is no more than 2.
How can I put a restriction on them so that once C11 equals 2 that no more entry is allowed?
Thanks.
Bookmarks