Alternate Row Shading Using Excel Conditional Formatting

Posted by accountingweb on Sep 17 2002 326 printer friendly

One way to make your data legible is to apply cell shading to every other row in a range. Excel's Conditional Formatting feature makes this a simple task.

Select the range that you want to format
Choose Format, Conditional Formatting
In the Conditional Formatting dialog box, select Formula Is from the drop-down list, and enter this formula: =MOD(ROW(),2)=0.
Click the Format button, select the Patterns tab, and specify a color for the shaded rows.
Click OK twice to return to your worksheet.

The best part is that the row shading is dynamic. You'll find that the row shading persists even if you insert or delete rows within the original range.

Voice of the Editor

What would you do if one of your clients won the lottery? We asked several accountants to weigh in with their advice for the lucky Powerball winner, and the tips we received are useful for anyone who receives a windfall, whether it's a lottery win, an inheritance, a big bonus on the job, or a killing in the stock market.

This Week on AccountingWEB

CPAs Mira Finé, Scott Hitchcock, Rob Keasal, Kathy Scorcio, and Ken Travis offer ten pieces of financial advice for the newest Powerball winner.

Hang Bower of BDO USA and Dan Black of Ernst & Young share their perspectives on why their firms made the Best Places to Work for Recent Grads 2013 list.

Herbein + Company, Inc. firm members talked with AccountingWEB about their year-round employee wellness program.

Bill Walter of Gross, Mendelsohn & Associates and Harold Gaar of TravisWolff LLP weigh in on mobile technology use while employees are at work.