Is there any way to highlight the largest number in a column, I need it to be to where if one of the numbers changes, and it's higher than the one already highlighted, the highlighting will move from the old # to the new one???
Is there any way to highlight the largest number in a column, I need it to be to where if one of the numbers changes, and it's higher than the one already highlighted, the highlighting will move from the old # to the new one???
Assuming column A, select the whole column, choose conditional formatting and enter the Formula Is formulaOriginally Posted by rae1222
=A1>=MAX(A:A)
HTH
select entire column and go to Format|Conditional Formatting...
Choose Cell Value Is from 1st drop down and enter formula =MAX(A:A) where A is the column you are in.
Click Format and pick highlight from Pattern tab....
Click Ok and Click Okay again
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Ohh! Thanks!
Ok... Well, I tried it, but it's just not working. I'm sure that's what I'm supposed to do... I don't understand why it's not highlighting? I put everything in right & chose a pattern color, & when I click on Conditional Formatting it displays it correctly, it's just not highlighting!
Did you use my suggestion?
If yes, you need to also make sure to select "Equal To" in the 2nd drop down menu... I kinda' forgot to mention that....
Make sure that the formula is not enclosed in double-quotes either...sometimes Excel adds those if you don't enter it correctly at first.
Ohh! Ok, I removed the quotation marks... now it works!! Thanks so much!
Okk... so now I have another problem. I am making a chart that contains the largest number from each column of my worksheet, and the name that coincides with that number. I used the MAX function to pull the largest numbers from the columns into my table, but now I'm not sure what function to use to make the names appear beside the numbers... I want to use a function, so that if I edit the table numbers the correct names will show as well... any suggestions??
=Index(B:B,Match(Max(A:A),A:A,0))
where A:A house the numbers and B:B house the coinciding names
Oh, wow, thanks! I never would have figured that out. & I thinkk that's all the questions I have! Thanks so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks