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