+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - No Results

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    67

    Conditional Formatting - No Results

    Hi Guys,

    I was wondering if someone could have a quick look at my spreadsheet and see if they can see why my conditional formatting isnt working. I have been looking at it for ages and cannot spot the problem. basically the row colour should change depending on what the person types in column B. so if they type the following they get the following line colour:

    "Pending" = line colour yellow
    "On Cover" = line colour green
    "NQ" = line colour grey
    "Quoted" = line colour Blue
    "Diaried" - line colour blue

    for some reason they are not working! any help as to why is much appreciated!!
    NEW TRACKER.xlsm

    thanks
    clare
    Last edited by toclare84; 02-08-2012 at 10:59 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Conditional Formatting - No Results

    You have space at the end of every word in B column.

    Remove space (select B column and Ctrl+H replace space with nothing) or add it in CF criteria

  3. #3
    Registered User
    Join Date
    07-20-2010
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: Conditional Formatting - No Results

    thank you very much!!! cant believe it was that simple!! your a star!!!

+ 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