+ Reply to Thread
Results 1 to 6 of 6

conditional formatting using words but exact words

  1. #1
    Forum Contributor
    Join Date
    10-31-2010
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    150

    conditional formatting using words but exact words

    basically ive got a table that i want to hightlight all cells that contain tba which is fine but it also highlight cells with football in it how can i make it only do the cells with just tba

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: conditional formatting using words but exact words

    In Conditional Formatting,

    Cell Value is:

    equal to

    ="tba"

  3. #3
    Forum Contributor
    Join Date
    10-31-2010
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    150

    Re: conditional formatting using words but exact words

    thats what i thought but for some reason its not working

    im using excel 2007

    i highlight my table
    go to conditional formatting
    new rule
    format only cell that contain
    then
    specific text
    containing
    then if i do tba they all highlight and if i do "tba" none highlight

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: conditional formatting using words but exact words

    After creating the rule go back and Edit the rule and see if the quotation marks are correct.

    You may have double quotations which makes it highlight only cells with tba within quotations, which you don't have and, therefore, no highlighting.

    Also make sure to check in the Applies To area to make sure your complete table is selected.
    Last edited by Cutter; 12-02-2010 at 01:53 PM.

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: conditional formatting using words but exact words

    After reading your last post again I would advise you try another method:

    Delete the rule you have then:

    New Rule > Format only cells that contain >
    Now: leave the first drop down as Cell Value
    next drop down change to: equal to
    next area: tba (no quotes)
    apply your formatting and OK out of the dialog boxes

    you should be done

  6. #6
    Forum Contributor
    Join Date
    10-31-2010
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    150

    Re: conditional formatting using words but exact words

    perfect all working

+ Reply to Thread

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