+ Reply to Thread
Results 1 to 6 of 6

Search and highlight hits only in Column C

Hybrid View

  1. #1
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,411

    Re: Search and highlight hits only in Column C

    The attached file shows how something similar can be achieved with conditional formatting. Enter a keyword or phrase in cell K1 (yellow), and if it is found in column C the whole cell is highlighted. The CF condition in cell C2 is:

    =ISNUMBER(FIND($K$1,C2))

    which makes it case-sensitive (try "the" and "The" in K1). If case is not important then you can change FIND to SEARCH.

    Hope this helps.

    Pete
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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