Filter and highlight based on list
You can auto highlight in Excel using conditional formatting, and filtering is easy based on single values but in this video I show how you can do that for multiple values held in a list! I show what happens when you are in a Table, and ow to use Excel's advanced filter including filtering my multiple columns as you go.
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...
00:00 Introduction
00:24 Filter based on list
01:49 Filter by multi column lists
03:17 Highlight based on criteria intro
06:11 Importance of Active Cell
07:01 Highlight entre row