Question 1: =if(a1=100,"Game Over, "&a1&"has reached 100
pts",if(a2=100,"Game Over, "&a2&"has reached 100 pts","")
http://www.officearticles.com/excel/...soft_excel.htm
Question 2: Click on the cell and choose Data--Validation. Pick LIST from
the dropdown and type into the box: Good,Bad,Average
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"TeddyTash" wrote in message
...

Hey all, hope you can help with these two minor things.

Question 1:
Is it possible to:
In a contest between 2 people, first to reach 100pts.
A1 is "Adam" (Player 1's Name)
A2 is "Mary" (Player 2's Name)
B1 is Player 1's score
B2 is Player 2's score

If B1 or B2=100, then F1 displays a message such as "Game Over:
'Players Name' has reached 100 pts"

Hope this can be done as it would be a nice feature.


Question 2:
Is it possible to:
Make it so that a cell will only allow you to enter "Good", "Bad" or
"Average" and make it refuse anything else. (of course it would have to
be able to be left blank until filled in)


Thanks in advance.

~Teddy


--
TeddyTash