+ Reply to Thread
Results 1 to 4 of 4

Way to highlight cell when searching for a partial value / text?

  1. #1
    Registered User
    Join Date
    08-25-2014
    Location
    Louisiana
    MS-Off Ver
    2014
    Posts
    17

    Way to highlight cell when searching for a partial value / text?

    I use the search function often when trying to find out a particular coding for material. Ex: I know that the material is a 12 x 6 x 3/8 Rect. Tubing. This material also has a heat code. At times I search the code by the dimensions, other times I search for the dimensions by the code. Is there a way to set the find feature to highlight the particular cells so that I can browse through them easily?

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Way to highlight cell when searching for a partial value / text?

    Conditional formatting should allow you to highlight cells based on their contents.

  3. #3
    Registered User
    Join Date
    08-25-2014
    Location
    Louisiana
    MS-Off Ver
    2014
    Posts
    17

    Re: Way to highlight cell when searching for a partial value / text?

    Quote Originally Posted by hoyasaxa215 View Post
    Conditional formatting should allow you to highlight cells based on their contents.
    I can do this already, but I need it to highlight specifically when I search on the fly.

  4. #4
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Way to highlight cell when searching for a partial value / text?

    The easiest way to accomplish this would be to use an excel add-in such as kutools, which will allow you to select cells that contain certain criteria, and then you could just format/highlight the cells once they're selected. Does lots of other things as well. See link below.

    http://www.extendoffice.com/product/...ells-rows.html

+ 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] 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. Highlight Exact and Partial Text, 2 Sheets
    By TPA Skooly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-11-2013, 03:50 PM
  3. Replies: 4
    Last Post: 07-27-2013, 07:38 AM
  4. [SOLVED] Help using VBA to highlight a partial column based on text in a cell out of the range
    By JTKEXCEL in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-20-2013, 04:46 AM
  5. Replies: 2
    Last Post: 10-12-2012, 11:18 AM

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