Trying to use =ISNUMBER(SEARCH()) with conditional formatting
Hi all, can't quite figure out what is happening, maybe conditional formatting doesn't accept formulas like this?
In my sheet, I'm trying to highlight specific rows if one of their cells contains the word "loaned". We have items we are tracking, some are bought, loaned, etc. It's super important we know what was loaned as we have to return it in it's original condition.
I'm using this formula =ISNUMBER(SEARCH("LOANED",$J57)) applied to the range A5:L120
If any cell in A5:L120 contains the word "loaned" then make the row of that cell highlighted red.
I used the identifier $ in $J57 to indicate that this search applies to all of column J not just J57.
I tried the following:
- Applying the formula only to row 57 to see if there was an issue with searching within the larger range.
- Removing the $ identifier incase that caused a circular formula.
- I tried applying the formula as an array formula: =ARRAY(ISNUMBER(SEARCH("LOANED",$J57)))
- I tried only using ISNUMBER and SEARCH formulas.
What am I missing? Any help is appreciated <3