Coloring Even Numbered Rows in a List

To color even numbered rows:

1. Select a cell in the region and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the Current Region.
2. From the Format menu, select Conditional Formatting.
3. For Condition 1, select Formula Is, and insert the following formula in the Formula box:
=MOD(ROW(),2)0
4. Click Format, and select the Patterns tab.
5. Choose any color, and then click OK twice.
Screenshot // Coloring Even Numbered Rows in a List
Coloring Even Numbered Rows in a List

Comments

  1. I am trying to put this into the middle of a spread sheet. I want it to immediatly skip 3 rows then color 1 and skip 3 more and then color 1. Can anyone help with this one? Thank you.

  2. "the tip given does not work, or am I missing something. I type exactly the suggested tips and got the dialogue box ""not enough arguments"".
    thans & great stuff tho"

  3. I am trying to put this into the middle of a spread sheet. I want it to immediatly skip 3 rows then color 1 and skip 3 more and then color 1. Can anyone help with this one? Thank you.

  4. "the tip given does not work, or am I missing something. I type exactly the suggested tips and got the dialogue box ""not enough arguments"".
    thans & great stuff tho"

Leave a Reply to Corey Cancel reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.