If you color code data in your cells you can very quickly filter your list to show only cells containing a certain color.
- All you have to do is right-click and select Filter | Filter by Selected Cell’s Color.
- Once you have finished, you simply turn off your AutoFilter arrows using a key combination shortcut: CTRL + Shift + L.
Pretty cool huh?