Use Conditional Formatting to Highlight in Excel

Instead of scanning all of the information in a spreadsheet, use conditional formatting to highlight when issues exist. Then all you will need to do is look for colorful indicators.
 conditional formatting in excel
The conditional formatting formula, in this case, is:
 conditional formatting in excel
Conditional formatting is a great way to reduce the time spent on tedious tasks.

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!