This Excel trick helps you find exactly what you're looking for in a heap of data

Conditional formatting in Excel allows you to format cells based on a set of rules. This will draw attention to the data you want to highlight and make your spreadsheets more user friendly.

Produced by Sara Silverstein

Follow BI Video: On Facebook

Business Insider Emails & Alerts

Site highlights each day to your inbox.

Follow Business Insider Australia on Facebook, Twitter, LinkedIn, and Instagram.