The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    2010 Excel Conditional Formatting Question

    Discussion in 'Windows OS and Software' started by AmazingGracePlayer, Jun 3, 2012.

  1. AmazingGracePlayer

    AmazingGracePlayer Notebook Deity

    Reputations:
    236
    Messages:
    1,737
    Likes Received:
    12
    Trophy Points:
    56
    I have a column in a table that has numbers as well as texts. I want to format it so that cells with numbers >180 will be highlighted. But the problem is that excel treats texts as numbers >180 so it highlights those... How can I fix this? What formula should I use under custom conditional format rule? I want to stay away from macro if possible.
     
    AmazingGracePlayer, Jun 3, 2012
    #1
  2. AmazingGracePlayer

    AmazingGracePlayer Notebook Deity

    Reputations:
    236
    Messages:
    1,737
    Likes Received:
    12
    Trophy Points:
    56
    Right now I have conditional formatting set to highlighting values between 180 - 9999, since my values usually do not exceed 5000. But I'm still curious to know how to highlight anything >180, but not texts.
     
    AmazingGracePlayer, Jun 3, 2012
    #2
  3. AmazingGracePlayer

    AmazingGracePlayer Notebook Deity

    Reputations:
    236
    Messages:
    1,737
    Likes Received:
    12
    Trophy Points:
    56
    +rep works like wonder, thanks bud
     
    AmazingGracePlayer, Jun 3, 2012
    #2