+ Reply to Thread
Results 1 to 4 of 4

How to have a formula become TRUE if a certain cell CONTAINS a word

  1. #1
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    122

    Lightbulb How to have a formula become TRUE if a certain cell CONTAINS a word

    Hi there,

    I'm including conditional formatting to highlight a cell (where a date should be entered) if the cell next to it contains certain words. In this particular case, I would like the date cell to highlight if the cell next to it contains the word URGENT. My current formula is:

    IF(A1="", B1="URGENT")

    But it does not work, I'm guessing because B1 actually says "URGENT: ISSUE SOA" instead of just "URGENT". I would change the CF formula, but I want this same rule to apply to dozens of cells, so short of re-typing every single rule for every single cell, I would like a way for my formula to look for if B1 CONTAINS URGENT rather than looking to see if B1 is exactly equal to URGENT.

    Hope this makes sense!
    Last edited by Keegan1116; 03-05-2020 at 11:42 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: How to have a formula become TRUE if a certain cell CONTAINS a word

    How about
    =AND(A1="", ISNUMBER(SEARCH("URGENT",B1)))

  3. #3
    Forum Contributor
    Join Date
    02-18-2020
    Location
    Ottawa, ON
    MS-Off Ver
    Professional Plus 2010
    Posts
    122

    Re: How to have a formula become TRUE if a certain cell CONTAINS a word

    It worked!! Thanks

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: How to have a formula become TRUE if a certain cell CONTAINS a word

    You're welcome & thanks for the feedback

+ 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. Replies: 6
    Last Post: 03-17-2019, 02:20 PM
  2. [SOLVED] Formula Help Pls - Search cell for WORD, return fields from WORD lookup
    By tomski777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2017, 12:02 AM
  3. [SOLVED] Formula to count how manytimes the word true happens in a row
    By pagsju in forum Excel General
    Replies: 7
    Last Post: 01-11-2016, 04:08 PM
  4. Excel formula switch first and Second word but keeps 3rd and remaining word in single cell
    By iwanttoexcelinexcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-29-2015, 04:22 PM
  5. [SOLVED] Search formula = If cell contains word located in another cell = true
    By BPSJACK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2014, 11:56 AM
  6. [SOLVED] Changing SUMIFS formula from word to word in a cell location
    By Car7os in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2013, 06:43 AM
  7. [SOLVED] How do I stop Excel from changing the word true to TRUE?
    By Schmyerlou in forum Excel General
    Replies: 1
    Last Post: 11-23-2005, 05:00 PM

Tags for this Thread

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