+ Reply to Thread
Results 1 to 5 of 5

How to color the cells of one colomn based on the values of another colomn???

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    13

    How to color the cells of one colomn based on the values of another colomn???

    In the 'FLOW TABLE' I need to color cells in to 3 different colors depending on the values of the "Operating issues" colomn, using Conditional Formatting.

    For example,
    If G cell is empty, then to color the relative cell in the 'FLOW TABLE' to the green.
    If G cell contains "HiCPL", then to color relative cell in the 'FLOW TABLE' to the red.

    In the attached file I showed two examples (green and red cells) in the 'FLOW TABLE' to make my question more clear. I need to cover cells with color only in the FLOW TABLE.

    Please someboby help me
    Attached Files Attached Files
    Last edited by Elza; 10-26-2012 at 10:18 AM.

  2. #2
    Registered User
    Join Date
    09-28-2010
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    2007 @ home, 2010 @ work
    Posts
    11

    Re: How to color the cells of one colomn based on the values of another colomn???

    Hi Elza,

    select K9 and insert conditional format
    new rule--> use a formula

    =VLOOKUP(K9,$E:$G,3,0)="HICPL,"
    and select your format.

    and again with the following rule
    =VLOOKUP(K9,$E:$G,3,0)=""
    and select your format.

    Go to manage rules and check the boxes "stop if true".

    now you can copy the cel K9 and paste format to the other cells in the table flow and it looks pretty cool :-)

    have fun!

    Ysball

  3. #3
    Registered User
    Join Date
    09-28-2010
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    2007 @ home, 2010 @ work
    Posts
    11

    Re: How to color the cells of one colomn based on the values of another colomn???

    Edit.

    Downside of this option: the text needs to be exactly the same, no extra spaces, nothing.
    however, its not caps sensitive.

    Good luck

  4. #4
    Registered User
    Join Date
    10-25-2012
    Location
    usa
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: How to color the cells of one colomn based on the values of another colomn???

    Oh my God! I love this Forum! Yaball thank you so much! It worked! Indeed it looks pretty cool

    Could you please explain how formula works?
    Last edited by Elza; 10-26-2012 at 02:27 PM.

  5. #5
    Registered User
    Join Date
    09-28-2010
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    2007 @ home, 2010 @ work
    Posts
    11

    Re: How to color the cells of one colomn based on the values of another colomn???

    Hi Elza,

    i'm happy to be of help, here's the explaination:

    =VLOOKUP(K9,$E:$G,3,0)="HICPL,"
    this "vlookup" formula searches column E for the information thats written in K9 and returns the 3rd collumn to the right of the cell he found.
    If this is the same as "HICPL," the equasion is True and your able to give it a format.
    if it is False the format stays the same.

    the other formula is the same except the "HIPCL," is changes by "" (empty cell).

    have fun!

+ 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