Display a warning when a cell with a formula reaches a certain number

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.

Hi,

You could try :

Please Login or Register  to view this content.

HTH

well you could right some vba code, althernatively in G3 put =IF(F3>60,"Day one limit reached","")
and you could conditionally format the whole sheet to turn it another colour using a formula to evalue with =$f$3>60 as the condition and choose a colour to catch their attention

regards

Dav

I'm not very familiar with code. Where would I put this code? I would love to try it.

Hi,

Point the Sheet tab name
Right click
select view code
and copy code ...
that's it ...

HTH