Highlight a row based on a single value
Filters are great for limiting what you see, but sometimes you want to compare records. When this is the case, conditional formats can distinguish records. Here's a data set of products with a conditional format highlighting only Condiment records.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.