One way:

Select your rows, with, say, cell A1 active. Choose Format/Conditional
formatting and use the dropdowns and inputbox to enter

CF1: Formula is =A1=MAX(1:1)
Format1: <patterns/<highlight color

In article ,
Emml wrote:

I want to the cell which contains the maximum value in the row to display a
colour.And then apply it to the other rows. This will help to identify the
maximum values in each row of data.