Excel’s Advanced Filter Features Made Easy : From Criteria Ranges to Copying Results

Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.
PC World

Can Excel Sort by Color? How to Fill Color and use Sort & Filter’s Custom Sort

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns/fields.