+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Multiple Text Values

  1. #1
    Registered User
    Join Date
    06-01-2012
    Location
    Boise
    MS-Off Ver
    Excel 2010
    Posts
    18

    Conditional Formatting Multiple Text Values

    I have one worksheet in a workbook with multiple names in one column... IE: Starting at Column A8 through A100

    I have 14 names of people that I have placed in Column A on a separate worksheet within the workbook. What is need to do is format each cell that shows one of the 14 names in it. I know I can do this individually as it works, just don't no how to include all 14 names...

    EXAMPLE: Column A If the Employee NAME in Column A matches one of the 14 MANAGER names in Column A on the sheet called MGR then highlight it light blue.

    I want to do this with conditional formatting.

    Thanks for any help in advance.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Conditional Formatting Multiple Text Values

    =countif(manager range,a1) eg
    use a formula to determine =COUNTIF(sheet2!$G$1:$G$14,A1) well i think you can use other sheets in 2010 otherwise you will have to create a named range for the managers
    Last edited by martindwilson; 06-04-2012 at 04:28 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    06-01-2012
    Location
    Boise
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Conditional Formatting Multiple Text Values

    Couldn't make that work. The names are on a separate sheet called MGR am I missing something?

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Conditional Formatting Multiple Text Values

    http://www.techrepublic.com/blog/mso...eferences/3727 for excel 2010 trouble is it wont work in 2007 or less
    but id name the range its easier
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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