Results 1 to 2 of 2

Thread: Advanced Filter

  1. #1

    Advanced Filter

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I am trying to run an advanced filter query to display rows based on the RAG status (B11). However in column B the underlying values of traffic lights (B2:B5) is -1,0,1. I have formatted the cells (B2:B5) using custom ("Red";"Green";"Yellow").

    Is there a way i could use (Red, Green and Yellow) as a data validation list in the cell B11 instead of (-1,0 and 1) to make the advanced filter functionality work?

    Attaching the sheet for reference



    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Don't you use icon sets in your CF. Instead, insert a solid circle symbol in the cell, and then use CF formulas, such as =A2="A" for Amber, and set the colour accordingly. Then you can use Filter by Color.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts