+ Reply to Thread
Results 1 to 3 of 3

conditional formatting to find specific words.

  1. #1
    Forum Contributor
    Join Date
    05-20-2013
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2010
    Posts
    255

    conditional formatting to find specific words.

    Hi.

    I'm trying to search in a column for the words "late" or "on time"

    I want late to be in red, and on time to be green.

    I've tried these, but they haven't worked worked:

    =$G3="late"

    =search("late", $G3)>0

    workbook is attached
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: conditional formatting to find specific words.

    Hello
    If you're just trying to conditionally format each cell to either red or green font based on 'Late' and 'On Time', then you only need to select the range of cells and go to the Home tab Conditional Formatting > Highlight Cell Rules > Equal to... and enter your conditions and chosen format.

    DBY

  3. #3
    Forum Contributor
    Join Date
    05-20-2013
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2010
    Posts
    255

    Re: conditional formatting to find specific words.

    Oh thanks! I'm not too familiar with conditional formatting!

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: conditional formatting to find specific words.

    Glad to have helped. Thanks for rep.

    DBY

+ 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. [SOLVED] Macro to find specific words and compare with a cell
    By kinirobin in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-27-2012, 10:18 PM
  2. Replies: 3
    Last Post: 03-26-2012, 11:18 AM
  3. conditional formatting using words but exact words
    By bopsgtir in forum Excel General
    Replies: 5
    Last Post: 12-02-2010, 02:51 PM
  4. Conditional formatting with words
    By koklok123 in forum Excel General
    Replies: 1
    Last Post: 03-04-2010, 02:41 PM
  5. how do I find an average number of specific words in a column
    By cashgrfx in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 01-06-2005, 01:06 PM

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