LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 15
Question 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

Last edited by TeddyTash : September 14th 05 at 12:30 PM Reason: change email notification
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A couple of questions... littlegreenmen1 Excel Discussion (Misc queries) 0 June 10th 05 09:40 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Couple more questions... Poor microsoft user New Users to Excel 1 April 27th 05 03:20 PM
New user with a couple of questions.... B Craig Excel Discussion (Misc queries) 6 February 11th 05 10:15 PM
An easy macro question and one I believe to be a little more diffi TroutKing Excel Worksheet Functions 3 January 18th 05 09:17 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"