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) |