+ Reply to Thread
Results 1 to 5 of 5

How to highlight the cell based on text

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    77

    How to highlight the cell based on text

    Hello Everyone,

    I have data in which I want to highlight the cell on the basis of text.

    For example:- I have a list of data in a range in that I want to highlight those cells which has contains "Tain".

    Thanks in advance
    Ankit

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: How to highlight the cell based on text

    Hi Ankit,

    Do you know about how to set a conditional format?

    Assume your text variable is in A1 - "Tain".

    Assume you want to look at data in column B, then use the following as your conditional format formula =IFERROR(FIND($A$1,B1),0)

    I hope this helps, please let me know!

    Regards,

    David

    Please remember, your request is clearer if you attach a sample workbook.
    - Click on Go Advanced and click on the Paper Clip.

    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

    If several people have responded, when you reply please make it clear WHO you are responding
    to by mentioning their name.
    Last edited by David A Coop; 06-11-2015 at 02:12 AM.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to highlight the cell based on text

    @ David, Conditional Formatting works on only TRUE or FALSE, so I think you can do away with the IFERROR part and just use...
    =FIND($A$1,B1,0)
    or even...
    =match($A1,B:B,0)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: How to highlight the cell based on text

    @Ford - good point! I guess I was testing in a cell before trying in the CF. Didn't think to take the iferror out.

    Regards, David

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to highlight the cell based on text

    I guess I was testing in a cell before trying in the CF.
    I often do that too, much easier thay testing in the CF window. When I do that, I structure the test formula to return TRUE or FALSE

+ 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. Replies: 6
    Last Post: 10-23-2014, 04:48 PM
  2. Replies: 2
    Last Post: 06-05-2013, 11:03 AM
  3. [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
  4. [SOLVED] Highlight row based on character/text string containing in cell.
    By dihris in forum Excel General
    Replies: 2
    Last Post: 12-03-2012, 11:16 AM
  5. Replies: 3
    Last Post: 08-28-2009, 11:16 AM

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