Identify max value for multiple variables?

Match1 Match2 Match3 Match4 Match5 Match6 Total
Home
Away
ABS difference
Winning team is H or A

I have 2 teams (Home & Away) playing 6 matches of multiple games. At the end of the match each team enters their score.

I can calculate:
1) The total for each team.
2) The difference between each team in each individual match using, =ABS(B2-B3)
3) In each match which team won using, =IF(B3>B2,A3,A2), Where teams (home& away) are at A2 & A3.

I would like to calculate which match has the highest difference for the Home team and same for the away team?

Can anybody help.

Hang on a second - I can't find my Crystal ball

..... seriously though.. Can you upload the file please - it makes it much easier !!

Hi and welcome to the forum

While Andy (Litch) finds his crystal ball, maybe you could add more detail to your question?

It would help tremendously if you could provide some sample data (workbook), showing what data you are working with, what your expected outcome would be, and how you arrived at that.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

1. Put =B2-B3 in B10 and paste it across to G10
2. =MAX(B10:G10) is then the highest Home team Goal diff win
3. =Abs(Min(B10:G10) ) is the highest Away team win

Bit awkward with the layout as it is but if conditional formatting is good enough then

1. In Cell B4 conditional format put =B4 = MAX($B$4:G$4) and format it
then copy/paste the format across B4:G4

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter the suggested formula