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
Bookmarks