Couple of hopefully easy questions
 

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

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

#1 right click sheet tabview codeinsert thisSAVE
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Or Target.Address = "$B$2" Then
If Target.Value = 100 Then MsgBox "Game Over"
End If
End Sub

#2 menu datavalidation

--
Don Guillett
SalesAid Software

"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

Hi Teddy,

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"


In cell F1 enter
=IF(OR(B1=100;B2=100);"Game over: " & IF(B1=100;A1;A2) & " has reached
100 pts";"")


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)


1. Select the cell!
2. Data/Validation/Settings(first tab)
3. In Permitted(first field) select List
4. In Source type Good, Bad,Average
5. Beside the cell (if selected) you see a down-arrow, clicking on it you
will see the choice, click on the desired option!

Have a nice game!
Stefi

Thanks guys, as always your solutions worked a treat.

~Teddy