This series — Excel Pro Tips — covers some of the best formulas, tables, conditional formatting, and other processes to help users manage their record keeping more efficiently. This week it looks at conditional formatting,which can change the formatting of cells to provide fast visual cues to potential discrepancies.