Conditional formatting data based on the maximum in the set

[Guest]

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.

 

[JE McGimpsey]

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>

 

[David Biddulph]

Format/ Conditional formatting/ Formula is: =A1=MAX(1:1)

 

[David Biddulph]

Or Format/ Conditional formatting/ Cell Value is: =MAX(1:1)

 

[Guest]

Thanks you ,McGimpsey and David Biddulph, for you ideas.
It worked !