A Better Way To Color Spreadsheet Gridlines


In the June 2004 JofA (page 80), a reader asked how to change the colors of her spreadsheet gridlines so she could easily identify the results of different months. I responded that while gridline color can be changed ( Tools , Options , View , Gridline color ), any change affects the entire worksheet—not just parts of it.

However, I failed to suggest the obvious and most simple solution for not only changing all the gridlines in a worksheet to one color, but also setting them to many different colors. Thankfully, one alert reader called it to my attention. Michael A. Berson, CPA, CFO of Sidney Fetner Associates, New York, says you can produce variously colored gridlines (see screenshot below) within one worksheet by using the Format Cells command.

To do that, highlight the cell or cells to which you wish to add color. Right-click in that highlighted space, left-click on Format Cells and click on the Border tab. Select your color from the drop-down menu and then either choose the type of border from the array of choices or click on any of the corner symbols or the word Text in the center box. When you’re satisfied with the color and arrangement, click on OK .



6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.


How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.