Conditional formatting in a cell formula

[gromit]

I am constructing a workbook which will hold a full season's fixtures
and results as the season progresses.

As there are 16 teams in the competition, there are 8 lines per week's
results (home team and away team per line). To simplify things,
basically this is how each week will look:

[Best viewed in a fixed pitch font]

| 1 | 2 | 3 | 4 | 5 | 6
A | Home Team 1 | Pts For | Pts Agst | Away Team 1 | Pts For | Pts Ag
[....]
H | Home Team 8 | Pts For | Pts Agst | Away Team 8 | Pts For | Pts Ag

Using Format | Conditional Formatting, I have set the team which has
the highest score, to be displayed in bold (i.e. cells A1 & A4). The
condition is that if A2 > A3 then make A1 bold. The same condition is
done for A4 i.e. if A5 > A6 then make A4 bold. The purpose of this is
so that the winner of each match can be seen easily as their team name
will be in bold. As there are 16 teams involved, I have to go through
this a further 15 times for each week's fixture. As there are 22
rounds to the season this means I will need to manually conditionally
format 352 cells (phew!). Can I achieve this in a simple cell formula?

Also, if this can be done am I able to copy with auto fill and have
the cell references updated to reflect this? I attempted to auto fill
the first cell (A1 in my above example) only to have the contents of
B1 an exact copy of A1 with comparison done on the cells in Row A (A2
& A3), not Row B as I expected (B2 & B3).

I am a novice at this sort of thing and am hoping to learn as well
find a solution to this problem.

Thanks in advance.

 

[Karl]

If you set the first one up you can use the format painter to paste it to
all others

the first conditional format would be

Formula Is (in the drop down) & =B1>C1
Format as required

Hope this helps

Karl