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
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.
Just what I wanted. Works great. Thanks.
"To make it work, type : =MOD(ROW():2)0
instead of :=MOD(ROW(),2)0
ie repalce the comma by "":"""
Works great for me.
I need to color every other VISIBLE row. Does anyone know how to do this?
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.
To color sequences of 3 rows change the formula to: =MOD(ROW(),6)<3
"Tip works for me. However, I would like three rows colored and then three not and then three colored, etc.
Can you help."
it does work, look at the screen shot
The tip given doesn't work.
"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"
Just what I wanted. Works great. Thanks.
"To make it work, type : =MOD(ROW():2)0
instead of :=MOD(ROW(),2)0
ie repalce the comma by "":"
Works great for me.
I need to color every other VISIBLE row. Does anyone know how to do this?
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.
To color sequences of 3 rows change the formula to: =MOD(ROW(),6)<3
"Tip works for me. However, I would like three rows colored and then three not and then three colored, etc.
Can you help."
it does work, look at the screen shot
The tip given doesn't work.
"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"