Thank you, Raffael. I found that worked if I "cell is" in the conditional
formatting box. Many thanks,
--
De


"Raffael" wrote:

Ok, in that case you're right and may use the "conditional formatting". I
have some personal spreadsheets that use this kind of logic.
So, you should select "Formula is" in the conditional formatting box, type
something as "=MAX($A1:$BZ1)" and select the formatting that you want to
highlight the cell with the max value in that row.
One way you can do that is selecting the entire matrix, making sure that the
line in the formula would be the same as the one in the formula. You must
block the columns, but not the rows.

Regards



"De" wrote:
Thanks, Raffael, but I wondered if there was a conditional format etc that
might do it as I have 200 rows and 58 columns of data. I have entered a
"max" formula for each row and need to know which cell in each row
contains
the "max" result.
--
De


"De" wrote:


--
De