+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Formula Not Working Properly

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Conditional Formatting Formula Not Working Properly

    Hi there,

    I want this formula to switch on the conditional formating when the 'Shipment Type' = "Agent", the 'Service' is NOT "Door-to-Door", and the 'From/To' field = "To".

    The formula I created works for the first two conditions, but fails when it comes to picking up "To" values.

    Any help would be much appreciated.

    Rgds,

    Oscar.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,573

    Re: Conditional Formatting Formula Not Working Properly

    In your conditional formatting formula, you need to change the IF to AND, like this:

    =AND(O3<>"Door to Door",R3="Agent",W3="To")

    Hope this helps.

    Pete

+ 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] Conditional Formats Not Working Properly When Copied
    By Oscar Martin in forum Excel General
    Replies: 2
    Last Post: 01-28-2014, 01:48 PM
  2. Conditional formatting not working properly
    By mlucey01 in forum Excel General
    Replies: 4
    Last Post: 01-08-2013, 08:35 PM
  3. [SOLVED] Conditional Formatting using VBA - Code not working properly
    By Tejas.T in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2012, 10:19 AM
  4. AND in Conditional Formatting Formula not working
    By readyemail in forum Excel General
    Replies: 11
    Last Post: 11-30-2010, 06:00 PM
  5. using a formula in conditional formatting not working
    By missmischa in forum Excel General
    Replies: 4
    Last Post: 02-22-2010, 06:04 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