This isn’t so much a cool “magical” tip as much as it’s a reminder to myself that it exists and I should use it more often. Excel has a Conditional Formatting feature that allows you to apply rules to a spreadsheet to have certain data situations display in different ways automatically.