Advanced Filter

Sachin

New member
Joined
Jul 3, 2014
Messages
1
Reaction score
0
Points
0
Hello,

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

Regards

Sachin


 

Attachments

  • Traffic Lights (1).xlsx
    70.9 KB · Views: 9

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
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.
 
Top