+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - Format one cell based off of text from other cells

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Conditional Formatting - Format one cell based off of text from other cells

    New guy here, thanks in advance for any help.

    I'm trying to get a cell formatted for color, based off if the text matches a range of cells from another worksheet.

    Example:

    Cells A2:A6 in sheet Results are as follows:
    ARI
    IND
    BAL
    SD
    NYJ
    OAK

    I want cell B2 in sheet Picks to be filled in Green if any of the choices from A2:A6 are there. If not, it should be filled in red.

    Any ideas? Is there one formula that can encompass all the choices or to I have to have one rule per possible result?
    Dan Felock
    US Navy

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,806

    Re: Conditional Formatting - Format one cell based off of text from other cells

    Use following CF in cell B2
    Please Login or Register  to view this content.
    for the green condtion and

    Please Login or Register  to view this content.
    for the red one

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,243

    Re: Conditional Formatting - Format one cell based off of text from other cells

    You could also just color the cells red, and just use 1 CF rule to change them green?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Workaround to Conditional Formatting based on a Format of another cell
    By sarkman22 in forum Excel General
    Replies: 5
    Last Post: 05-10-2013, 01:24 PM
  2. [SOLVED] Conditional Formatting (changing color) in one cell based on text in two cells
    By Chadyoung1 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-14-2013, 04:26 AM
  3. Using Conditional Formatting to format range based on one cell
    By panamakevin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2012, 09:50 PM
  4. Replies: 2
    Last Post: 12-21-2011, 06:01 PM
  5. [SOLVED] Conditional formatting of adjacent cells based on text in cell
    By elderain@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 07:20 PM

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