Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am new to excel 2007. I want perform certain tasks on this spreadsheet.
1) Highlight in Yellow the winning team (Example:Teams=B6 or B7) along with C6 or 7:W6 or 7) when entering the actual scores in X6 and X7. 2) Count the highlighted X's (Up to 17 games in a week) and add them in Row 1 column C:W. 3) Automatically highlight winners name by using highest wins #and closest to total combined score. I realize this can be confusing without looking at the sheet itself. where can I e-mail a copy for viewing and assistance. -- Thanks! Marcos R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automate extraction of data from mainframe report into spreadsheet | Excel Discussion (Misc queries) | |||
Football Tourament Spreadsheet - Sorting a table automatically. | Excel Discussion (Misc queries) | |||
Football pool | Excel Discussion (Misc queries) | |||
Automate Spreadsheet | Excel Worksheet Functions | |||
Fantasy Football | Excel Discussion (Misc queries) |