Results 1 to 5 of 5

Conditional formatting for duplicate text.

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2014
    Location
    Lisbon, Portugal
    MS-Off Ver
    2010
    Posts
    2

    Conditional formatting for duplicate text.

    I have a column of names and a corresponding column of cities that these people are from. Once these people send in a certain application, I copy their names and cities into a separate sheet. I do this by week. The problem I am having is that when I want to quickly see who who has already been entered in over the weeks. Is there any way that I can make it so that when I put in a city and name, and then later in another sheet put in the same city and name, the original cell turns green. Is that possible? to highlight duplicate sets of cells that have no numerical values?

    I have a sample of how I want it to be in the end. The names in green are those who have their name under "completed" in either of the 2 sheets.
    Attached Files Attached Files
    Last edited by lisbonmission; 09-30-2014 at 06:18 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Duplicate Conditional Formatting
    By jbtenor1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2014, 11:14 AM
  2. [SOLVED] Conditional formatting of duplicate rows (not duplicate cells)
    By ExcelStefan in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 06:09 AM
  3. Conditional formatting for duplicate values
    By kris26 in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 03-21-2012, 06:51 AM
  4. duplicate conditional formatting
    By detlion1643 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2009, 01:11 PM
  5. How can I duplicate conditional formatting
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:35 PM

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