Results 1 to 5 of 5

Cannot get Conditional Formatting formula to work with wildcard characters.

Threaded View

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

    Cannot get Conditional Formatting formula to work with wildcard characters.

    Hi there. I'm having trouble getting a conditional formatting formula to work. You will find it in the attached spreadsheet; it is the only active conditional format in the Manage Rules tool. I want it to highlight the selected cells purple if the following conditions are met:

    that the 'Mode' is equal to 'Road', AND the 'Booker' is equal to 'Interdean Brussels';

    AND the 'Origin Agent' OR 'Destination Agent' fields have the word 'Interdean' in them.

    I've nested the AND/OR functions together in the formula because I want the last two conditions to be either/or. But I think what is causing the problem is the wildcard character. I've never used it before and I'm not sure if I'm using it correctly. Basically if 'Origin Agent' or 'Destination Agent' have the word 'Interdean' in them I want them to qualify as part of the conditions.

    Would really appreciate any help with this.

    Oscar.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting with a Wildcard
    By Orestees in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2012, 10:21 AM
  2. Replies: 1
    Last Post: 07-19-2012, 05:37 AM
  3. Change formula to work in conditional formatting
    By efernandes67 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-04-2011, 03:06 AM
  4. Conditional Formatting Formula Will not work
    By jdunkel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2007, 09:24 AM
  5. [SOLVED] How do I use wildcard characters in Excel 2003 sumif formula?
    By Erik T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 04:45 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