Excel Guru Needed...

[JonB]

Hello,

I can't find anyone in my office who knows how to solve this problem. Hopefully someone on here will be able too

The problem is this. I have a lot of data that I want to be able filter. I'd also like the row colours to alternate. However when I filter the data, this happens.





Does anyone know how to keep the cell formatting seperate to the cell contents, if that makes sense?

Many thanks for your help,

Jon

 

[JonB]

Ok, I've written a macro to do this. How would I get it to automaticall run when a user filters the data?

Thanks.

Jon

 

[JonB]

Oh thanks muchly. Much easier than having to use macros.

Anychance you could explain the formula bit to me?

Thanks

Jon

 

[JonB]

Ah brilliant, thanks.

Just as a side note, does excel produce a Worksheet_Change event when you filter data? Or is there a filter event at all?

Jon

 

[JonB]

Ok, thanks for your help.

 

[JonB]

Any recomendations for general Excel Books. Ones which cover 'bits of everything'? Thanks