Results 1 to 10 of 10
  1. #1
    Lounger
    Join Date
    Jul 2005
    Location
    Benbrook, Texas, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bowl Game Tracking (2003)

    I am trying to keep track of the college bowl games and would like some help from excel.

    I have about 30 people in the "pool". I have all the names in column A and each of their corresponding picks out to the right.

    I would like to be able to type in the winner of each game at the top of the column and have excel highlight the winners.

    I would also like to have excel put the names in order of most right to most wrong. I am sure this will have to be done with a macro, but I don't know the code well enough to figure it out.

    I hope you can help. Thanks in advance.

    Below is a small example:
    If this were in excel, I would like the CSU in craigs row to be highlighted red and also the UT and CSU in Johns row.

    SM Tol Cal Na
    Brian C SM Tol Cal Na
    Craig S SM Tol Cal CSU
    John H UT Tol Cal CSU

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bowl Game Tracking (2003)

    Can you provide more information for those who don't have the slightest idea what college bowl is?
    What is the meaning of the data you provided?
    Why should CSU and UT be highlighted? I assume because they won their game, but how would Excel "know" this?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bowl Game Tracking (2003)

    How is this sample?

    Enter the winner in row 6 (change to whatever abbreviations you used). They will automatticlly be highlighted (I used conditional formatting) The formula in Col A calculates the number correct. Just select a cell in col A and press the "sort descending" button on the toolbar (Z>A) and it will be sorted in descending order.

    [I think I got all the current bowl games ...]
    Steve

  4. #4
    Lounger
    Join Date
    Jul 2005
    Location
    Benbrook, Texas, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bowl Game Tracking (2003)

    The bowl games will be played through January and I wanted to keep track of who has guessed the most correct answers. After the games are played, the winning team will be entered into row 1.

    I want excel to highlight the losing team and then sort the rows from most right to the most missed (most highlighted). That way the person who has guessed the most right will be on top. In the attached file Dirk is where he belongs at the bottom, but then just above him should be Al, Cheek, and John (preferably in alphabetical order).

    Also, how can I keep excel from highlighting answers that haven't been entered? I used conditional formating to highlight the answers.

    Thanks for your help.

    Will this require a macro?

    I have attached what I have so far.

  5. #5
    Lounger
    Join Date
    Jul 2005
    Location
    Benbrook, Texas, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bowl Game Tracking (2003)

    That works too. But how about putting them in order of most right to most wrong? That way we can tell imediately who is winning the "pool". I am sure it will require a macro, but I am not familiar enough with code to do this.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bowl Game Tracking (2003)

    How about this?

    Steve

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bowl Game Tracking (2003)

    If you sort by number correct it is most right to most wrong. Sorting on col A does this without a macro by using the "sort descending" button...

    Steve

  8. #8
    Lounger
    Join Date
    Jul 2005
    Location
    Benbrook, Texas, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bowl Game Tracking (2003)

    That'll work. Although, I was going to highlight the loser in red, and leave the correct answers alone. How difficult would that be to change?

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bowl Game Tracking (2003)

    Select C9:AD36
    Format -cond formatting
    Formula is
    =AND(C9<>C$6,C$6<>"")
    <format>
    pattern(tab)
    select "red"
    <ok><ok>

    Steve

  10. #10
    Lounger
    Join Date
    Jul 2005
    Location
    Benbrook, Texas, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bowl Game Tracking (2003)

    Thanks. Works like a champ.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •