Hi Guys
Thanks to Chandoo's email, I use this formula to create a zebra strips =Mod(Row(),2)=0.
I'd like to know how to keep the zebra strips in the table when I'm sorting it based on a criteria? Right now when sorting the table, I might get 2 row or even more with the same color..
Thanks,
Amit
Thanks to Chandoo's email, I use this formula to create a zebra strips =Mod(Row(),2)=0.
I'd like to know how to keep the zebra strips in the table when I'm sorting it based on a criteria? Right now when sorting the table, I might get 2 row or even more with the same color..
Thanks,
Amit