Hi Tom

My apologies.
I just looked at Cathy's sheet on her website, and saw she had used the
following as a test in her Conditional Formatting
=MAX($B4:INDIRECT(CONCATENATE($T4,ROW())))
This led me to think she was looking for the highest value in the row.
I have now read the rest of the thread, and I can see that she was
asking for something different.

--
Regards

Roger Govier


"Tom Ogilvy" wrote in message
...
Just for information, she doesn't want the highest value in the row.

--
Regards,
Tom Ogilvy


"Roger Govier" wrote in message
...
Hi Cathy

To return the column number of the highest value in the row it is
=INDEX($B$3:$S$4,1,MATCH(MAX(B4:S4),B4:S4))+1

For your conditional formatting, use the dropdown to select Formula
Is
rather than Cell Value
Condition 1, Formula Is =B4=MAX($B4:$S4)
Condition 2, Formula Is =B40

--
Regards

Roger Govier


"Cathy" wrote in message
...
Think this is all just slightly out of my league.

Your formula works perfectly, however I am struggling to find a way
to
use conditional formatting to highlight the 4 numbers used in
calculation in light blue and the number discarded in red.

I have made the changes as per your formula and reloaded the sheet

http://www.greenwichyachtclub.co.uk/racing/Book1.xls

I guess I am looking for column t to show the column number of the
5th
value counting from the left but if there is an easier way then I
will
be all ears.

Thanks again in advance for any assistance.

Kind regards
Cathy