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

"David Biddulph" wrote:

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Format/ Conditional formatting/ Formula is: =A1=MAX(1:1)

"Emml" wrote in message
...

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.