Shade Alternating Rows Or Columns

BY STANLEY ZAROWIN

Q. How do I create a formula that automatically formats a worksheet with alternating rows of shading so it resembles a columnar pad?

A. The easiest way is with Conditional Formatting . Begin by highlighting the rows you want to format—presumably an entire worksheet—by clicking on the blank cell to the left of column A and above the 1.

Then click on Format , Conditional Formatting to open the function’s window. Under Condition 1 , press the down arrow and select Formula Is and add this formula: =mod(row(),2)=1 . If you want the shading to begin with the second row, rather than the first, substitute 0 for the 1.

To choose the color, click on the Format button and then on the Patterns tab to evoke this screen:

After you select the color, you’ll be returned to the Conditional Formatting screen. Finish by clicking on OK and your spreadsheet will look like this:

If you want to shade alternating columns instead of rows, use this formula: =mod(column(),2)=0.

 

SPONSORED REPORT

A new line of business to consider

Technology assessments may open the door to new engagement opportunities for your firm. What is a technology assessment? How do you perform one? JofA Tech Q&A author J. Carlton Collins shows you in a detailed explanation.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.