Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: coloring rows based on column content

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok I have a column with data that will be one of three words, resolved escalated or terminated. Depending on which word is in the column I would like to change the color of the row to green yellow or red.

    Any help would be appreciated

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Use conditional formatting.
    On Worksheet Menu click Format, Conditional Formatting.

    Good Luck!

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,658
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-24 06:23, Nozama wrote:
    Ok I have a column with data that will be one of three words, resolved escalated or terminated. Depending on which word is in the column I would like to change the color of the row to green yellow or red.

    Any help would be appreciated
    It would have been much easier to know which range of cells are of interest and which column holds the words...

    Lets say that A2:D40 is the range of interest and column D holds those key words.

    Select A2:D40.
    Activate Format|Conditional Formatting.
    Choose 'Formula Is' for 'Condition 1'.
    Enter in the formula Box:

    =$D2="resolved"

    Activate Format.
    Select, say, green, on the Patterns Tab.
    Click OK.
    Activate Add.
    Choose 'Formula Is' for 'Condition 2'.
    Enter in the formula Box:

    =$D2="escalated"

    Activate Format.
    Select, say, red, on the Patterns Tab.
    Click OK.
    Activate Add.
    Choose 'Formula Is' for 'Condition 3'.
    Enter in the formula Box:

    =$D2="terminated"

    Activate Format.
    Select yellow on the Patterns Tab.
    Click OK.
    Click OK.

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Nozama

    Nothing to do with your problem, but are you using a Validation list for you 3 entries? If not, check the feature out under Data>Validation



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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