+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Assistance

  1. #1
    Forum Contributor
    Join Date
    05-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    Office Standard 2016
    Posts
    266

    Conditional Formatting Assistance

    I'm looking for assistance in the formula for conditional formatting. I want excel to highlight the row if $E12 does not contain the text that resides in $V12. It does not have to be an exact match, but it needs to contain the words at minimum of whats in $V12. For example, if $E12 said "Engineer / BLD SYSTEM" and V12 states "Engineer" that would not highlight as the first cell contains the word engineer.

    I took a stab at it, but it did not work:

    =$E12<>"*" & $V12 & "*"

    Thanks for the help.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,814

    Re: Conditional Formatting Assistance

    Try this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Assistance with Conditional Formatting
    By mbyng1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2016, 01:56 PM
  2. conditional formatting assistance? HELP!
    By TRAZ6666 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-31-2016, 03:01 PM
  3. assistance with conditional formatting
    By PeterG in forum Excel General
    Replies: 3
    Last Post: 10-29-2015, 05:39 PM
  4. Conditional Formatting Assistance
    By St34d in forum Excel General
    Replies: 3
    Last Post: 03-25-2015, 04:43 PM
  5. Conditional Formatting assistance please
    By MnMCarta in forum Excel General
    Replies: 2
    Last Post: 12-12-2014, 11:21 AM
  6. Conditional formatting (i think) assistance
    By gosox25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2010, 11:04 PM
  7. Conditional Formatting Assistance
    By JimMay in forum Excel General
    Replies: 4
    Last Post: 05-15-2006, 06:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1