Would you like to be able to scan your company’s financial operations spreadsheet and instantly see which departments are over budget or behind schedule or which accounts receivable are past due? There’s an easy way to do that in Excel, which can automatically flag cells that meet most any condition you establish. You can set the cells to display different formatting flags-colors, font styles, shading, patterns, underlining-with each custom format identifying a specific financial condition. Here’s how.
Authors: Charles Kelliher, Lois S. Mahoney
Source: Journal of Accountancy
Subject: Productivity / Work Tips