Use Conditional Formatting to Highlight

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.
Example:
article02_01-1
 
 
 
 
 
 
 
The conditional formatting formula, in this case, is:
article02_02-1
 
 
 
 
 
 
 
Conditional formatting is a great way to reduce the time spent on tedious tasks.
For more office techniques see our MS Office Tips.