Hi,
I am looking for a formula that does the following.....

C1 through C16 values are set to 0
B1 has a value of 100
Data entered into C1 through C16 has to be greater than or equal to
B1, but can be 0 (it just can't be 1 - 99)
In cell D1 I need a formula that results with any type of notification
that a number has been entered into C1 through C16 1 - 99

Any assistance on this would be greatly appreciated. Thanks!