one way.....
set a cell with the max value of the row eg
=MAX(A1:IV1)
then use conditional formatting for the row with the condition
'Cell Value is' 'Equal to' and the reference to the cell with the MAX
formula in it
Choose the color of the condition you require.

--
Cheers
Nigel



"Greg" wrote in message
...
Hi all,

I have a spreadsheet which is dynamic and I would like it to highlight the
highest total in a row and then to colour it with the grey colour which I
think is 15.

How is this done?

Thanks in advance

Greg