Conditional formatting help needed

[TGV]

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

 

[Fred Smith]

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

Regards,
Fred.

 

[Max]

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]

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

 

[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

 

[Max]

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

 

[Joerg Mochikun]

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

 

[Joerg Mochikun]

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

 

[Fred Smith]

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.

 

[TGV]

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

TGV

 

[Max]

Welcome, good to hear
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik