+ Reply to Thread
Results 1 to 4 of 4

Help creating pool (Super Bowl)

  1. #1
    Registered User
    Join Date
    08-13-2009
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    13

    Help creating pool (Super Bowl)

    Hi, I want to create a "simple" 10 x 10 spreadsheet. Then add a value surrounding the the grid that represent the last digit of the score per quarter of the game. I would like to manually put each teams' score in 2 unrelated cells and have the corresponding cell that intersects the score (horizontally first) be highlighted in the grid. I have no idea how to start this, I guess I have been out of the loop too long.
    Thanks for your help!
    Last edited by snapajap; 01-28-2013 at 12:09 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Help creating pool (Super Bowl)

    Here's a few links that may help

    Templates:
    http://office.microsoft.com/en-us/te...101927371.aspx
    http://plannet.net/plannet-giving-aw...ools-template/

    Site:
    http://www.mygridpool.com/

  3. #3
    Registered User
    Join Date
    08-13-2009
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Help creating pool (Super Bowl)

    Thanks AlphaFrog!
    I still want to be able to create my own. Here'a what I have so far

    =IF(AND($M$3=B$1;$N$3=$A2))

    So it works, I just can't remember how to get a result other than TRUE or FALSE

    Thanks again!

  4. #4
    Registered User
    Join Date
    08-13-2009
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Help creating pool (Super Bowl)

    Never mind, I got it!
    =IF(AND($N$4=C$2;$O$4=$B3);Winner;"Looser")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1