Select columns A:AO
FormatConditional Formatting...Formula is:
=a1=max(a:a)
Set the format you want
OK out.

Regards,
Fred.

"TGV" wrote in message
...
Hi

I am having numerical data from A1 to AO (A1:AO) like that the data is
available for 1500 rows. Now I want to Highlight the Maximum Value which
is
present in every rows (A:AO). Whether it is possible in conditional
formatting? If so, please guide me how I can do it.

Thank in advance.

TGV

Thanks for your suggestions, but both of the answers are not resolved my
issue. Please go through my post once again I want to highlight each rows
maximum value. Anyone pls help me.

Thank you,

TGV


"Fred Smith" wrote:

Select columns A:AO
FormatConditional Formatting...Formula is:
=a1=max(a:a)
Set the format you want
OK out.

Regards,
Fred.

"TGV" wrote in message
...
Hi

I am having numerical data from A1 to AO (A1:AO) like that the data is
available for 1500 rows. Now I want to Highlight the Maximum Value which
is
present in every rows (A:AO). Whether it is possible in conditional
formatting? If so, please guide me how I can do it.

Thank in advance.

TGV

Change Fred's code to
=a1=max(1:1)

OK, if you want to be exact then you can write:
=a1=max($A1:$AO1)

Don't forget to copy the format to all cells in your table

Joerg

"TGV" wrote in message
...
Thanks for your suggestions, but both of the answers are not resolved my
issue. Please go through my post once again I want to highlight each rows
maximum value. Anyone pls help me.

Thank you,

TGV


"Fred Smith" wrote:

Select columns A:AO
FormatConditional Formatting...Formula is:
=a1=max(a:a)
Set the format you want
OK out.

Regards,
Fred.

"TGV" wrote in message
...
Hi

I am having numerical data from A1 to AO (A1:AO) like that the data is
available for 1500 rows. Now I want to Highlight the Maximum Value
which
is
present in every rows (A:AO). Whether it is possible in conditional
formatting? If so, please guide me how I can do it.

Thank in advance.

TGV

P.S. I noticed that Fred suggested to select columns A:AO. Formatting whole
columns could result in a huge file size. Beside there are other pitfalls
that can prevent proper cell references.

The safest way: Apply the formula only to A1, then copy the format only
(with format painter or format special) across the row to AO1, then down as
needed.

Joerg


"Joerg Mochikun" wrote in message
...
Change Fred's code to
=a1=max(1:1)

OK, if you want to be exact then you can write:
=a1=max($A1:$AO1)

Don't forget to copy the format to all cells in your table

Joerg

"TGV" wrote in message
...
Thanks for your suggestions, but both of the answers are not resolved my
issue. Please go through my post once again I want to highlight each
rows
maximum value. Anyone pls help me.

Thank you,

TGV


"Fred Smith" wrote:

Select columns A:AO
FormatConditional Formatting...Formula is:
=a1=max(a:a)
Set the format you want
OK out.

Regards,
Fred.

"TGV" wrote in message
...
Hi

I am having numerical data from A1 to AO (A1:AO) like that the data is
available for 1500 rows. Now I want to Highlight the Maximum Value
which
is
present in every rows (A:AO). Whether it is possible in conditional
formatting? If so, please guide me how I can do it.

Thank in advance.

TGV

Good point, Joerg. It would have been more efficient for me to say "select
your entire data table", then enter the conditional formatting formula.

The other way to copy conditional formats, which I prefer, is to right-drag
the cell over the data table, and on release, choose Fill Formatting Only.

Regards,
Fred.

"Joerg Mochikun" wrote in message
...
P.S. I noticed that Fred suggested to select columns A:AO. Formatting
whole columns could result in a huge file size. Beside there are other
pitfalls that can prevent proper cell references.

The safest way: Apply the formula only to A1, then copy the format only
(with format painter or format special) across the row to AO1, then down
as needed.

Joerg


"Joerg Mochikun" wrote in message
...
Change Fred's code to
=a1=max(1:1)

OK, if you want to be exact then you can write:
=a1=max($A1:$AO1)

Don't forget to copy the format to all cells in your table

Joerg

"TGV" wrote in message
...
Thanks for your suggestions, but both of the answers are not resolved my
issue. Please go through my post once again I want to highlight each
rows
maximum value. Anyone pls help me.

Thank you,

TGV


"Fred Smith" wrote:

Select columns A:AO
FormatConditional Formatting...Formula is:
=a1=max(a:a)
Set the format you want
OK out.

Regards,
Fred.

"TGV" wrote in message
...
Hi

I am having numerical data from A1 to AO (A1:AO) like that the data
is
available for 1500 rows. Now I want to Highlight the Maximum Value
which
is
present in every rows (A:AO). Whether it is possible in conditional
formatting? If so, please guide me how I can do it.

Thank in advance.

TGV