Having a conditional formatting migraine! Please help!

**Friedtater22** · 04-25-2014, 09:31 PM

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!

**protonLeah** · 04-25-2014, 09:43 PM

deleted by bvj

**Mazzaropi** · 04-25-2014, 09:47 PM

Friedtater22, Good evening.

Try to do:

--> Select B3:O27
--> Conditional Format Menu
--> Formula
--> =ISNUMBER(SEARCH("MOVED TO",$J$3))
--> Choose your favourite colour
OK

Is it what you want?
I hope it helps.

**Tony Valko** · 04-25-2014, 09:51 PM

Maybe something like this...

=LEFT($J3,8)="moved to"

**Friedtater22** · 04-26-2014, 03:00 AM

I tried this and it worked like a charm! Thank you so much!

Originally Posted by Tony Valko

Maybe something like this...

=LEFT($J3,8)="moved to"

**Tony Valko** · 04-26-2014, 01:55 PM

You're welcome. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.