Results 1 to 6 of 6

Conditional Formatting Based on Values in another Cell

Threaded View

  1. #3
    Registered User
    Join Date
    09-12-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Conditional Formatting Based on Values in another Cell

    I take it back. This solution is not 100% accurate. Would really appreciate help!


    Column AColumn B
    New YorkBoston
    CaliforniaChicago
    BostonCalifornia


    Based on this example, I would like to conditionally highlight "California" and "Boston" in column A because they matched values in column B.

    How can I do that, please???
    Last edited by jdegeorge; 09-12-2013 at 02:16 PM. Reason: Added example

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting based on 3 different cell values
    By Stephen.Birch in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-21-2013, 10:16 AM
  2. Conditional Formatting based on cell values
    By nickbrandon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2013, 08:26 AM
  3. Conditional Formatting based on several cell values
    By jpruffle in forum Excel General
    Replies: 3
    Last Post: 09-28-2009, 08:02 AM
  4. Conditional Formatting based on 3 different cell values (criteria)
    By xlguy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2007, 05:36 AM
  5. conditional formatting based on values of another cell
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2005, 04:05 AM

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