+ Reply to Thread
Results 1 to 3 of 3

Highlight row based on character/text string containing in cell.

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    London, Canada
    MS-Off Ver
    Excel 2010
    Posts
    9

    Highlight row based on character/text string containing in cell.

    Hello Folks,

    I know that this probably has been discussed here in the forum multiple times but I just can't nail down the proper solution for my case.
    What I have is bunch of data in Column A. What I'm trying to do is to highlight row from (A to L) based on cell value in Column A where cells containing character "#" in their value should highlight row in yellow and cells containing string "object" in their value should highlight row in green.
    Now so far I was able to find a formula for each conditional formatting:

    =(SEARCH("#",A1)>0) - for cells containing "#" within their value
    =(SEARCH("object",A1)>0) - for cells containing "object" within their value

    The problem is that when I set conditional formatting with the formulas above I'm able highlight respected cells but not rows.
    Where I''m doing this wrong?

    Thanks
    Last edited by dihris; 12-03-2012 at 11:18 AM.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Highlight row based on character/text string containing in cell.

    hi dihris. you just need the "$" sign to do an absolute reference. you also don't need the brackets surrounding the formulas"
    =SEARCH("#",$A1)>0
    =SEARCH("object",$A1)>0

    what you saying is to always look in column A, but move down the row when comparing in the next row. before applying, you must also remember to highlight from top left to bottom right (i.e. from A2 to L10 for eg)

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    London, Canada
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Highlight row based on character/text string containing in cell.

    Thank You benishiryo.
    With your correction I was able to do exactly what I wanted.

+ 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