Conditional formatting help needed
 

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

Conditional formatting help needed
 

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

Conditional formatting help needed
 

Easy. Select entire* cols A to AO (A1 active)
then apply CF using Formula Is:
=AND(ISNUMBER(A1),A1=MAX($A1:$AO1))
Format to taste Ok out

*Select the col headers, sweep it from col A to col AO so that A1 is the
active cell
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"TGV" wrote:
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

Conditional formatting help needed
 

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

Conditional formatting help needed
 

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


"Max" wrote:

Easy. Select entire* cols A to AO (A1 active)
then apply CF using Formula Is:
=AND(ISNUMBER(A1),A1=MAX($A1:$AO1))
Format to taste Ok out

*Select the col headers, sweep it from col A to col AO so that A1 is the
active cell
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"TGV" wrote:
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

Conditional formatting help needed
 

It should have worked fine. If it doesn't, then I'd suspect that your data
within cols A to AO are not all real nums but either all text nums or a
mixture of text nums and real nums. Convert the source data all at one go to
all real nums like this. Copy any empty cell, select cols A to AO,
right-click paste special check "Add" ok. Then re-apply the CF as
suggested earlier. It should work ok now (I've just simulated the scenario
over here, tested fine).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"TGV" wrote:
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.

Conditional formatting help needed
 

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

Conditional formatting help needed
 

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

Conditional formatting help needed
 

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

Conditional formatting help needed
 

Thank you max it's working fine..............

TGV

"Max" wrote:

It should have worked fine. If it doesn't, then I'd suspect that your data
within cols A to AO are not all real nums but either all text nums or a
mixture of text nums and real nums. Convert the source data all at one go to
all real nums like this. Copy any empty cell, select cols A to AO,
right-click paste special check "Add" ok. Then re-apply the CF as
suggested earlier. It should work ok now (I've just simulated the scenario
over here, tested fine).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"TGV" wrote:
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.

Conditional formatting help needed
 

Welcome, good to hear
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"TGV" wrote in message
...
Thank you max it's working fine..............