Conditional Forting - Make different row color work with autofilte
Steen
Yes.
Have you tried it and did not get what you wanted?
Gord Dibben MS Excel MVP
On Wed, 20 Dec 2006 14:33:01 -0800, Steen
wrote:
Hi
I am using the Conditional format formulat: =MOD(ROW(),2)=0 to color each
2'nd row in a different background color. Is it possible to make this work
even with filtered data (still coloring each 2'nd row when filter is active)?
/Steen
|