| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
alternate row shading kept with autofilter
Dear experts,
I have a range which can be autofiltered by users and it's in alternate row shading (conditional formatting, =mod(row(),2)). However, when users select their autofilter criteria, the alternate shading is broken so it is not really usfeul any longer. Is there a way I can keep it? Many thanks in advance for your help. Best regards -- Valeria |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alternate row shading kept with autofilter
=MOD(SUBTOTAL(3,$A1:$A$2),2)=0
Gord Dibben MS Excel MVP On Wed, 21 Apr 2010 01:24:01 -0700, Valeria wrote: Dear experts, I have a range which can be autofiltered by users and it's in alternate row shading (conditional formatting, =mod(row(),2)). However, when users select their autofilter criteria, the alternate shading is broken so it is not really usfeul any longer. Is there a way I can keep it? Many thanks in advance for your help. Best regards |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alternate row shading kept with autofilter
Works very well, thank you very much!
-- Valeria "Gord Dibben" wrote: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Gord Dibben MS Excel MVP On Wed, 21 Apr 2010 01:24:01 -0700, Valeria wrote: Dear experts, I have a range which can be autofiltered by users and it's in alternate row shading (conditional formatting, =mod(row(),2)). However, when users select their autofilter criteria, the alternate shading is broken so it is not really usfeul any longer. Is there a way I can keep it? Many thanks in advance for your help. Best regards . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alternate row shading kept with autofilter
You're welcome
Thanks for the feedback. Gord On Wed, 21 Apr 2010 08:21:01 -0700, Valeria wrote: Works very well, thank you very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternate Row Shading (Visible Rows Only) | Excel Worksheet Functions | |||
| How do I maintain alternate row shading after inserting a new row | Excel Discussion (Misc queries) | |||
| How do I set up alternate row shading with Excel 2003? | Excel Discussion (Misc queries) | |||
| Alternate shading colors | Excel Discussion (Misc queries) | |||
| Alternate Shading | Excel Discussion (Misc queries) | |||
Hybrid Mode
