Sponsored Link

Sponsored Link

Tuesday, October 7, 2008

Shade alternate rows using conditional Formatting

This post is very useful when you want to make your reports look really professional without spending lot of time. There are many templates provided by Microsoft which has alternate shaded rows.

MS Office 2003:

1. Select all the row and columns using CTRL + A keys on keyboard or by clicking on top left hand side corner.
2. Click on Format Menu -> Select Condition Formatting.
3. From the drop down, select the option Formula.
4. Enter the Formula enter =MOD(ROW(),2)
5. Row() function returns the number of row 1, 2, 3 and so on and Mod function basically return you the remainder after the division by 2

  • Mod ( 1 ,2 ) will return 1
  • Mod(2,2) will return 0
  • Mod (3,2) will return 1

6. Click on format button
7. Select the patterns tab and select the suitable color
8. Click on Ok and Ok.

In the above example, we learned two functions ROW() and MOD(). In future, I will post more functions which will use these functions in combination with other functions.

Also, do post your comments about this post and CLICK HERE to see updates on your email.


Post a Comment