Results 1 to 5 of 5

Conditional format a cell if value is found in list on another sheet

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706

    Conditional format a cell if value is found in list on another sheet

    Good day, Gurus.

    Not sure if this can be done. Column T in my workbook requires an entry, on any number of rows, for the country of origin. The entry in that column must exactly match the abbreviation for that country, which I have stored in a list on a separate hidden worksheet.

    Do I use conditional formatting or data validation to color this cell red if a user enters a value not found in my list, and can you please offer an example of how to best accomplish it?

    Thanks in advance for any help you can offer.
    Last edited by hutch@edge.net; 01-22-2014 at 12:37 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Set conditional format based on value in cell on active sheet
    By graphicgoose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2013, 09:38 PM
  2. Replies: 3
    Last Post: 05-15-2013, 12:16 AM
  3. [SOLVED] Excel 2003: How to conditional format if cell contains any of a list of keywords
    By doublefour in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-07-2012, 09:28 AM
  4. [SOLVED] Change cell contents if found in a list on another sheet
    By fastcar in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-05-2012, 08:29 PM
  5. automatically copy a cell (due to a conditional format) to another sheet
    By marc eber in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2008, 12:19 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