I have a data with say around 500 rows and want to determine MAX for each row and HIGHLIGHT them, also if data in all cells is zero then it should ignore and highlight none.
I have tried this formula
=B2=(MIN(IF($B2:$E2>0,$B2:$E2))).
But this highlights all the zeroes, you can refer attachment for sample....Please let me know if you have a solution
May be this.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks a lot!!!!This works.....................
You're welcome. Thanks for the feedback and rep.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Its solved Done!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks