+ Reply to Thread
Results 1 to 4 of 4

Multiple Filters or Advanced Search Criteria not working in conditional formatting

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    4

    Multiple Filters or Advanced Search Criteria not working in conditional formatting

    I have created a spreadsheet that will show me where people are working on what day, etc. however i want to be able to filter by week to create a list of say 2 particuar shifts - in this case "syl ld" and syl n so that the spreadheet would show the people who are working these shifts and I could print out. I have tried Multiple Filters and Advanced search but cannot achieve what I require - Can somebody please advise.
    Thanks
    Attached Files Attached Files
    Last edited by cookywales; 07-18-2014 at 07:32 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Multiple Filters or Advanced Search Criteria not working in conditional formatting

    Hi cookywales

    The attached spreadsheet does almost as you ask. The important cell is AM2; you may want to hide columns c:AK.

    Let me know how you get on.

    Regards
    Alastair
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-05-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Multiple Filters or Advanced Search Criteria not working in conditional formatting

    Many thanks - works perfectly - exactly what I wanted - I really appreciate what you have done.

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Multiple Filters or Advanced Search Criteria not working in conditional formatting

    Hi cookywales

    Glad it works for you. Perhaps you will mark this thread as "Solved"? Go to your first post where you are able to amend the title.

    Regards
    Alastair

+ 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] Search Funcation, Select boxes and Hyperlinks with existing Advanced Filters
    By sammyp1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2014, 11:27 PM
  2. [SOLVED] VLOOKUP with multiple search criteria not working.. Need Help.
    By xlyfe in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-10-2013, 01:01 PM
  3. creating VB code using advanced search criteria with multiple data validation lists?
    By Jonathan Bay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2011, 09:56 AM
  4. Advanced filters with multiple criteria
    By Alicita in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-01-2011, 09:24 AM
  5. Multiple Filters ,Advanced Filter and Autofilter
    By capetownandre in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2009, 03:23 AM

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