Conditional formatting data based on the maximum in the set
 

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.

Conditional formatting data based on the maximum in the set
 

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.

Conditional formatting data based on the maximum in the set
 

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

"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.

Conditional formatting data based on the maximum in the set
 

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.

Conditional formatting data based on the maximum in the set
 

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.