You may even want to include your criteria formulas right in the spreadsheet. 4. Use named ranges. As we saw with formulas, named ranges simplify reading and maintaining color formulas compared to scattered cell references. 5. Explore add-ins. Many add-ins boost Excel’s color features. Use...