Reader Feedback

BY STANLEY ZAROWIN

Reader Feedback

The August 2001 issue presented a way to shade alternate rows in Excel worksheets so they look like a columnar pad. A reader, Jason S. McKeever, a technology trainer at Eide Bailly LLP of Fargo, North Dakota, suggested a faster way:

Select the worksheet you want to format and highlight all of it by double-clicking in the box to the left of the A row and above the 1 column.

Then click on Format and Conditional Formatting . When the Conditional Formatting screen appears, click on the arrow to the right of Cell Value Is until Formula Is appears, and enter the following formula in the box: =MOD(ROW(),2)=1

Then click on Format and select the color or shade you want to apply to the alternating rows and click on OK. That will format the entire worksheet in one step.

SPONSORED REPORT

Implementing a global statutory reporting maturity model

Assess your organization's capabilities and progress toward an ideal state of global statutory reporting. Sponsored by Workiva.

100th ANNIVERSARY

Black CPA Centennial, 1921–2021

With 2021 marking the 100th anniversary of the first Black licensed CPA in the United States, a yearlong campaign kicked off to recognize the nation’s Black CPAs and encourage greater progress in diversity, inclusion, and equity in the CPA profession.