Results 1 to 3 of 3

Thread: Having a conditional formatting migraine. Please Help!

  1. #1

    Exclamation Having a conditional formatting migraine. Please Help!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,481
    Articles
    0
    Excel Version
    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.

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,551
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Last edited by Pecoflyer; 2014-04-27 at 09:20 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •