I am not even sure if there is a way to do this but here goes. I am creating a registration form for a conference we are having. I will not be the person filling this form out. For the first day we have a limit on the number that can attend. At the moment I have the spreadsheet calculating the number attending the conference according to the day(s) they choose whcih is basically a simmple caculation of adding choice 1 (which is the first day) and choice 2 (which is both days). I have this located right at the top of the form and highlighted so the individual taking registration will see. I tried to use data validation to create a senerio where the cell would create a message saying the limit had been reached once 60 was met but it does not work because the cell is automatically increasing and as far as I can tell what I tried only works if you are actually typing in the cell.
Does anyone know of a way that I could do this while still keeping my formula in the cell? I am attaching a small sample of the spreadsheet. Cell F3 is the cell I am working with.
Thanks for any assistance you might be able to give.
Bookmarks