Try Conditional Formatting:
1) Select the cells containing the totals
2) Select FormatConditional Formatting
3) From the dropdown list on the left select Formula Is
4) In the formula window paste the following formula. The formula assumes
that the cell range containing the totals is A10:J10. Change to suit:
"=A10=Max($A$10:$J$10)"
5) Click the Format button
6) Select the Patterns tab
7) Select the desired highlight colour

Regards,
Greg


"Greg" wrote:

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