Organizing rows by number of correct conditions met.

This week, i set up a form for people to submit entries on who they think will win each game of the 2015 week 15 NFL match ups.

The match ups go by column, starting in 2 and ending in 159.

The rows, which have all the entries for each game by a specific user, go from B to Q.

I have conditions set for each column of match ups, color coding the correct team, and incorrect team.

Now i'd like to be able to re-organize each row from the highest number of correct game selections to the lowest, without having to tediously count it 158 times.

All the correct game winners are the same color in each column and row.

Use a formula in R to compare the predictions in B:Q to the actual results and count the number of correct matches, similar to the method that you have probably used to set up the color coding conditions.

You should then be able to use the integrated sort function on R to organise the sheet as required.

I set up the color coding conditions by just opening up a new condition, inputting the range, and put a green background color for each winning team and a red background color for each losing team, i didn't use a formula for that part.

I do not know a formula i could use that will count the number of the specific background color per row.

Assuming that the correct winning teams to compare to are in row 1, something like

=SUMPRODUCT(--(B$1:Q$1=B2:Q2))

Entered into R2 and filled down.

Without more detail on the exact layout of your sheet, or a sample version to look at, all I can provide are suggestions based on what I think you might have.