Results 1 to 12 of 12

Finding partial text in cells (could be conditional formatting or formula)

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    Connecticut
    MS-Off Ver
    Excel 2010
    Posts
    50

    Finding partial text in cells (could be conditional formatting or formula)

    Hi,

    I think it should be pretty easy, but I can't figure out a quick way of doing this. I want to find any matches (variations) of a text string in a data set.

    In the attached spreadsheet, there is no consistency in the Item names. I'm looking to find all the possible box names. If it has any combinations of "A-Box", "A Box", "abox", etc. or any other way that "a box" can be written, I want to know about it (in the spreadsheet, A2, A4, A6, A8, A10 would match that criteria). This could be done through Conditional Formatting of the Item column or through a lookup formula (I'm open to any suggestions).

    Please let me know of any your thoughts. Thank you in advance for your help,

    Yury

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting based on partial/specific text to highlight entire row
    By bizdevdfw in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-18-2016, 04:32 PM
  2. finding partial text in an index match formula
    By garyaw in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-30-2015, 04:27 PM
  3. Need a 'conditional formatting' formula to highlight cells between dates/text
    By BigSean762 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2014, 02:33 PM
  4. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  5. [SOLVED] Conditional formatting formula based on text in two cells
    By lionrookie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2014, 12:50 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