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.