Results 1 to 13 of 13

Conditional formatting: Highlight cells in a column that contain 1 or more words

Threaded View

CEM Conditional formatting:... 05-05-2012, 01:21 PM
FDibbins Re: Conditional formatting:... 05-05-2012, 02:10 PM
jeffreybrown Re: Conditional formatting:... 05-05-2012, 02:24 PM
CEM Re: Conditional formatting:... 05-05-2012, 02:30 PM
CEM Re: Conditional formatting:... 05-05-2012, 02:40 PM
jeffreybrown Re: Conditional formatting:... 05-05-2012, 02:44 PM
CEM Re: Conditional formatting:... 05-05-2012, 03:03 PM
FDibbins Re: Conditional formatting:... 05-05-2012, 03:05 PM
jeffreybrown Re: Conditional formatting:... 05-05-2012, 03:10 PM
CEM Re: Conditional formatting:... 05-05-2012, 03:25 PM
jeffreybrown Re: Conditional formatting:... 05-05-2012, 03:36 PM
CEM Re: Conditional formatting:... 05-05-2012, 03:56 PM
jeffreybrown Re: Conditional formatting:... 05-05-2012, 03:58 PM
  1. #1
    Registered User
    Join Date
    09-02-2010
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2003
    Posts
    18

    Conditional formatting: Highlight cells in a column that contain 1 or more words

    Conditional formatting: Highlight cells in a column that contain 1 or more of a set of words.

    Below: I want all cells in colum B that contain the words "CAT", "MONKEY", or "BULL" highlighted regardless of other punctuation or words in the cell.

    I found the following formula but it does not work:
    =IF(ISERROR(IF(LEN(B1)>0, FIND(","&LOWER(B1)&",", ",cat,monkey,bull,"),#VALUE!)),"=",B1)


    Please see attached spreadsheet.

    A B
    1 CAT TIGER
    2 MAN
    3 CHICKEN, DONKEY854
    4 DUCK" SNAKE
    5 MAN
    6 SNAKE, MONKEY 2658
    7 MONKEY: TIGER
    8 MAN(
    9 DOG, BIRD 4564
    10 BIRD, SNAKE
    11 TIGER, DONKEY
    12 MAN
    13 LION, MONKEY
    14 BULL, LION
    15 DONKEY, TIGER
    16 MAN
    17 COW, SNAKE..4
    18 PIG, COW
    19 MAN
    20 OWL, MONKEY

    Notice some words are not separated by spaces or are followed by or preceeded by punctuation (if the word is in complete I want the cell to be highlighted regardless of what is before or after).

    I am using Excel 2003, and was told the above formula should be entered in the cell vale/equal to....

    Thank you,
    Daniel
    Last edited by CEM; 05-05-2012 at 01:26 PM. Reason: more info

Thread Information

Users Browsing this Thread

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

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