auto-filter in excel but leave cell background color

T

Tony

I want to create a simple chart with alternating row colors to easily read
data. When I auto-filter the data it moves the cell color. I want to keep
nice alternating rows.
 
G

Gord Dibben

Tony

Select the rows you want with alternating shading.

Format>Conditional Formatting>Formula is:

=MOD(ROW(),2)=0

Format to a color and OK

Alternating row colrs will stick through filtering.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Not correct...........please see Max's post for correct.

Gord

Tony

Select the rows you want with alternating shading.

Format>Conditional Formatting>Formula is:

=MOD(ROW(),2)=0

Format to a color and OK

Alternating row colrs will stick through filtering.


Gord Dibben MS Excel MVP
Click to expand...

Gord Dibben MS Excel MVP
 
Top