filtered rows getting shaded alternately (conditional formatting)

A

andreashermle

Dear Experts:

The following formula (=MOD(SUBTOTAL(3,$A$1:$A2),2) as a conditional
format keeps up alternate shading even if a list is filtered

Now I would like to use a macro solution to automate this process with
the following requirements:

- The List is in Sheet 1 and has the following name: 'Sheet 1!
DataList'
- The macro solution should allow for extension of the list below the
named range, i.e. a dynamic named range is to be used in the macro
- Alternate grey shading is to be applied

Help is much appreciated.

Thank you very much in advance.

Regards, Andreas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shading a row red as soon as a cell entry in column L says "Error" 4
Alternate Column Shading to be applied only to visible columns 6
Apply Alternate Shading to selected rows 2
Mail Merge Directory Conditional Page Break 0
Insert name and adress from a list in a word document 1
count shaded cells with a gradient fill 3
Conditional formatting if condition of an if statement is true and astring value is displayed 2
Copy yellow shaded rows to another worksheet 2

Top