Having a conditional formatting migraine. Please Help!

friedtater22

New member
Joined
Apr 26, 2014
Messages
2
Reaction score
0
Points
0
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!
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,169
Reaction score
11
Points
38
Excel Version(s)
365
Select B3:O27
Go into conditional formatting dialogue via New Rule
Select rule type Use a formula to determine…
enter this in the Format values whre this formula is true field:
=SEARCH("MOVED TO",$J3)>0
(this is where you must ensure that row 3 is the topmost row of your selection prior to going into the dialogue)
Choose your formatting
OK. OK.
 
Top