Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Fill every other row with color
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Fill every other row with color

We're going to learn how to fill every second row of your sheet with color using conditional formatting in Excel.

 
  Author: mat | Version: 2010 | 23rd November 2011 |  
 
 
1.
 

Open a document you want to apply conditional formatting in.

 
 
2.
 

Select the cells.

 
 
3.
 

Click the Conditional Formatting button ...

 
 
4.
 

... and choose New Rule...

 
 
5.
 

In the New Formatting Rule window select Use a formula to determine which cells to format.

 
 
6.
 

Enter =mode(row();2) into Format values where this formula is true field.

 
 
7.
 

Click Format.

 
 
8.
 

Click the Font tab and choose font Color.

 
 
9.
 

Select the Fill tab and choose cell color

Click OK.

 
 
10.
 

Click OK.

 
 
11.
 

Your Excel sheet should now have every other line filled with color of your choice.

 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO