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