I am attempting to search a row of data and highlight the cell that has MAX value.
How am I able to do this?
I would also like to run this in a loop so I can perform this function over multiple rows
I am attempting to search a row of data and highlight the cell that has MAX value.
How am I able to do this?
I would also like to run this in a loop so I can perform this function over multiple rows
Re: Max Value Search & Highlight
Quote from youngsie81I am attempting to search a row of data and highlight the cell that has MAX value.
How am I able to do this?
I would also like to run this in a loop so I can perform this function over multiple rows
1) Select the rows that u wanted to highlight
2) Goto Format menu and then click Conditional Formating
3) Then select the Cell Value Is in the first drop down
4) Then select the Equals to in the second drop down
5) In the third text box =max(selected_rows_name)
ex =max(a1:a6) will highlight the highest value found in the a1 to a6 rows
6) Click the Format button
7) Then select the Pattern tab
Click any color that you want to show up
9) Click ok
10) Click ok
Have a nice day.
cheers!!!!!
senthil
Re: Max Value Search & Highlight
Thank you for the quick response! It worked!
Is there anyway to run/create a macro that could do perform the function?
It would save me MASSIVE amounts of time.
Don’t have an account yet? Register yourself now and be a part of our community!