Results 1 to 3 of 3

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

Threaded View

  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.

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