Register now or log in to join your professional community.
It is a very easy function for filtering data with colours etc.
If you need to view your summarized data in a filtered form, try Pvot table .
It is the AND, OR and Formula as criteria to display the records that meet the criteria.