I'm trying to use conditional highlighting to highlight cells B3:O3 based on certain text that is in J3. I have figured out everything except for the formula to use for specific text followed by variable text. What I need is when J3 says "moved to" followed by a location, the row should be highlighted. I found online somewhere that I could use the formula "=$J3=ISNUMBER(SEARCH("MOVED TO",J3))=TRUE", but that doesn't work for me. For some reason, it highlights the row without anything being in J3. When I change the formula to "=FALSE), that doesn't work either. When FALSE is used, anything and everything that gets put into J3 highlights the row. My worksheet is A1:O27, with the headers being in rows 1 and 2. Data starts in B3. I need this to work in each row from B3:O27. PLEASE HELP!

Hi perhaps as CF ? The "True" or " false" part is implicit

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Please do not cross post without links http://www.excelguru.ca/forums/showt...-Please-Help!& http://www.excelforum.com/excel-gene...ml#post3674802

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post