Keep Track of Bowl Games

thetank

Board Regular
Joined
Mar 17, 2005
Messages
142
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
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

anthonya2369

Active Member
Joined
Mar 10, 2005
Messages
321
I wonder if just using Conditional Formatting and you input the winner as Green Background, if loser, then Red Background. Then have the total to the far right of All Correct Picks and then just do a Descending Sort and no macro needed.
 

thetank

Board Regular
Joined
Mar 17, 2005
Messages
142
I wanted to make it easy for others to check. You know, just type in the winner and hit enter and let excel do its thang.
 

Pekkavee

Well-known Member
Joined
May 25, 2004
Messages
1,218
You can do it with Conditional formatting like this.
Obs. $-sign in formatting.
Työkirja1
ABCDEF
1SMTolCalNa
2BrianCSMTolCalNa
3CraigSSMTolCalCSU
4JohnHUTTolCalCSU
5
6Conditional formatting in C2
7Cell is not egual to =C$1, then select red color
8Then copy formatting with format painter
9to all cells
10
Taul1


You can put an extra CF condition in cell C2 like

Cell is egual to =C$1, then select green color, so winners will be green cells.

Regards
Pekka
:eek: :eek: :eek:
 

Watch MrExcel Video

Forum statistics

Threads
1,123,380
Messages
5,601,279
Members
414,440
Latest member
Kim0204

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top