+ Reply to Thread
Results 1 to 9 of 9

conditional formatting/highlighting cells

  1. #1
    Registered User
    Join Date
    01-21-2008
    Posts
    13

    conditional formatting/highlighting cells

    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???

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Quote Originally Posted by rae1222
    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 formula

    =A1>=MAX(A:A)

    HTH

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    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.

  4. #4
    Registered User
    Join Date
    01-21-2008
    Posts
    13

    conditional formatting

    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!

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    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.

  6. #6
    Registered User
    Join Date
    01-21-2008
    Posts
    13
    Ohh! Ok, I removed the quotation marks... now it works!! Thanks so much!

  7. #7
    Registered User
    Join Date
    01-21-2008
    Posts
    13

    Ok New Problem: Referencing? Max Function?

    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??

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    =Index(B:B,Match(Max(A:A),A:A,0))

    where A:A house the numbers and B:B house the coinciding names

  9. #9
    Registered User
    Join Date
    01-21-2008
    Posts
    13
    Oh, wow, thanks! I never would have figured that out. & I thinkk that's all the questions I have! Thanks so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1