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.

hi
see if this site helps you out.

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

Regards
FSt1

"ybeckett" wrote:

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.

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"ybeckett" wrote:

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.

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

On Thu, 3 Dec 2009 13:06:02 -0800, Shane Devenshire
wrote:

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.