Hi Jim
check out data / validation
(choose whole number - between 1 & 5 ... you can also write your own error
messages on the error alter tab)
check out
www.contextures.com/tiptech.html
for additional details on using Data Validation
Cheers
JulieD
"Jim" wrote in message
...
I want to format a cell so that only specific numbers can be entered. For
instance only numbers between 1 and 5 can be entered. All other numbers
will
either force an error message or simply cannot be entered.