Excel - To Highlight Every Other Line a Particular Color

Overview: When printing a large spreadsheet, it may be useful to display rows in alternating colors for readability.

1. Select the area of cells.
2. From the top toolbar, click on FORMAT | CONDITIONAL FORMATTING.
Select Formula from the drop down menu and paste in this formula
=MOD(ROW(),2)=1
Select type of blue format you want
Click OK
If it does not work check to see if it has added quote marks to the formual, if so delete them.

My Blogs

Exploring Autism
Lackey Class of 86
Charles County Cafe

Blogs I Read

Adventures in Autism
Autism Diva
Autism Vox
Ballastexistenz
Daily Kos: State of the Nation
Grey Matter/White Matter
HuffingtonPost
Left Brain/Right Brain
MarksFriggin Blog
TomPaine.com
Whose Planet Is It Anyway?

News & Comment

CNN
Drudge Report
FactCheck
Google News
Media Matters
MSNBC
The Nation
New York Times
New York Daily News
New York Post
New York Sun
Salon
Slate
SOMDNews.com
Washington Post

Links

Andrew Sullivan
Bill Maher
Christopher Hitchens
Cost of the Iraq War
Dave Chappelle
Fallen in Iraq
Geekologie
George Carlin
Gizmodo
History Channel
History House
The History Place
History News Network
Howard Stern
Iraq Coalition Casualties
Kids-In-Mind
Lackey High School Class of 1986
New York Yankees
NNDB
Paul Mooney
Richard Dawkins
Sam Harris
Save Darfur
Set America Free
ThinkGeek
ThinkQuest
Thoreau Society
The Writings of Henry D. Thoreau
USHistory.org
U.S. Constitution

Favorite Music

Neko Case
Johnny Cash
Roseanne Cash
Kasey Chambers
Tracy Chapman
Shawn Colvin
Sammy Davis, Jr.
Iris Dement
Dixie Chicks
Steve Earle
Amy Farris
The Greencards
Emmylou Harris
John Hiatt
George Jones
Dean Martin
Maria McKee
Van Morrison
Old 97s
John Prine
Karl Straub
Whiskeytown
Kelly Willis
Lucinda Williams

Stomping Grounds

Facebook
MySpace

Other Stuff

Yard Sale!
Wish List (Buy Me A Present!)

National Debt