How to Filter by colour in Excel

How to Filter by Colour

Excel allows user to have an effective filtering tool with filtering by colour.
If you are browsing through your data, and highlight certain dates.
You are then able to filter these highlighted dates.
Select the data that you would like to filter
Select the data tab and click on the filter icon
Click the drop down arrow and select filter by colour
When you combine two functions together it is another useful tool
If you use built in Conditional format option - Highlight Cell Rules - Text that Contains
Combined with the Sort by Color - Sort by Cell Color
An example of this would be in a large data file that would have one column that would have were written in text.
The Comments would have a wide variety of text but the only text you are interest in are recommendations that say cold.

Select Conditional format option - Highlight Cell Rules - Text that Contains
Enter Cold in the text box
Select green fill with Dark Green text