Use a conditional format to do this and it will not move when you sort the
rows:-
Do CTRL+A, then Format / Conditional Formatting / Change 'cell value is' to
'formula is' and put
in =MOD(ROW(),2)=1
Now click on the format button and choose a nice pastel colour from the patterns
tab. Hit OK till
you are out and you are done.
You could also put in
=MOD(ROW(),2)=0 if you wanted the other rows to be coloured.
You could also put in
=MOD(ROW(),3)=0 if you wanted every 3rd row to be coloured.
You could also put in
=MOD(ROW(),4)=0 if you wanted every 4th row to be coloured.
You could also put in
=MOD(ROW(),5)=0 if you wanted every 5th row to be coloured.
But you probably get the drift by now. Flipping the 1 and the 0 will determine
whether or not you
start with a coloured or a non-coloured row.
If you want to create alternate green bars made up of say 3 rows (or any other
color), you can
also use:
For every three rows:
=MOD(ROW()-1,6)<3
For every four rows:
=MOD(ROW()-1,8)<4
For other number of shadings, just make the 2nd number (6 or 8 in example) twice
as much as the
3rd number (3 or 4 in example)
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
JackNYC said:
Excel Wizards,
Is there a way for Excel to "intelligently" maintain "striping" of rows in order to maintain readability?
I know that you can manually go in and change shading but when you're
adding/deleting/moving rows this is a big pain.
