1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel whizzkids can you help ?

Discussion in 'BlackHat Lounge' started by wannabie, Feb 23, 2011.

  1. wannabie

    wannabie Elite Member

    Joined:
    Mar 11, 2009
    Messages:
    3,807
    Likes Received:
    2,954
    Occupation:
    Seo and Marketing Suprisingly
    Location:
    Your bedroom window
    Home Page:
    [​IMG]


    Google hasn't been my friend on this one, but does anyone know I can get excel to highlight numbers to be red if lower or green if a figure is higher?

    Those are some stats for a website SERPS which colum one is today and the second was yesterday which I normaly do manully but surely there is a way to do it automatically?

    I hope that makes sense?
     
    Last edited: Feb 23, 2011
  2. JackSparrow

    JackSparrow Supreme Member

    Joined:
    Mar 24, 2007
    Messages:
    1,469
    Likes Received:
    2,054
    Occupation:
    Semi-Employed Pirate
    Location:
    search 4 blackhatsparrow
    Home Page:
    conditional formatting
     
  3. wannabie

    wannabie Elite Member

    Joined:
    Mar 11, 2009
    Messages:
    3,807
    Likes Received:
    2,954
    Occupation:
    Seo and Marketing Suprisingly
    Location:
    Your bedroom window
    Home Page:
    Tried that but that only works in the same column ?
     
  4. JackSparrow

    JackSparrow Supreme Member

    Joined:
    Mar 24, 2007
    Messages:
    1,469
    Likes Received:
    2,054
    Occupation:
    Semi-Employed Pirate
    Location:
    search 4 blackhatsparrow
    Home Page:
    I assumed you wanted cell B to be red if lower than cell A, or cell B to be green when higher than cell A. That's why i suggested conditional formatting this is how its done.
     
    • Thanks Thanks x 1
  5. wannabie

    wannabie Elite Member

    Joined:
    Mar 11, 2009
    Messages:
    3,807
    Likes Received:
    2,954
    Occupation:
    Seo and Marketing Suprisingly
    Location:
    Your bedroom window
    Home Page:
    Yes, Sorry dude my mistake

    The left colum is today and the other yesterday, so I want todays to highlight good from bad
     
  6. JackSparrow

    JackSparrow Supreme Member

    Joined:
    Mar 24, 2007
    Messages:
    1,469
    Likes Received:
    2,054
    Occupation:
    Semi-Employed Pirate
    Location:
    search 4 blackhatsparrow
    Home Page:
    Yes you use conditional formatting to do that, i will set the spreadsheet up for you if you are struggling with it.