coloured roes static while sorting data

[ybeckett]

I want to set up a list that has alternating coloured rows to make it more
legible but I want the coloured rows to remain static while the data is
sorted in various ways. Is it possible to do this? I have used the list
template in excel but the gray row colour is less than ideal. I want to use a
pale yellow and a pale green alternating.

 

[FSt1]

hi
see if this site helps you out.

http://www.cpearson.com/Excel/banding.aspx

Regards
FSt1

 

[Shane Devenshire]

Hi,

Select the range in question and apply conditional formatting:

Format, Conditional Formatting, Formula is from the first drop down
In the next box enter =MOD(ROW(),2)
Click the Format button and from the Fill tab pick a color.
Click OK twice.

 

[Gord Dibben]

If you also want to be able to preserve the banding when filtering.

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP