Out, Out, Green Triangles

BY STANLEY ZAROWIN

Q. Some cells in my spreadsheets contain little green triangles in the upper left-hand corner (see screenshot at right), and I can’t get rid of them, though sometimes—through no apparent effort on my part—they just disappear. Is my software infected with the dreaded green triangle virus?

A. No, it’s not a virus. Those green triangles are Excel’s way of telling you it believes the cells contain an error. Of course, sometimes Excel is wrong, but such error-flagging is a handy fail-safe function.

Why it happens: Excel 2002 and 2003 constantly work in the background scanning for possible errors. You can turn off the feature by clicking on Tools , Options and the Error Checking tab and unchecking the Enable background error checking . Then click on OK .

SPONSORED REPORT

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.