coloured roes static while sorting data

  • Thread starter Thread starter ybeckett
  • Start date Start date
Y

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.
 
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 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
 
Back
Top