Conditional formatting and filters

[penny]

I have a conditional format that shades every other row: =MOD(ROW(),2)=0. Is it possilbe, once data is filtered, for this format to apply to the filtered data?

Thanks!

[Paul]

From a post by Debra Dalgleish in 2003 (http://groups.google.com/group/micro...b5a33babb846):

========================================================
You can do this if you add a helper column to the table:

1. Insert a blank column (column A in this example)
2. Add a heading, e.g. Count
3. In row 2, enter the following formula, where column B
contains no blank cells within the table range:
=SUBTOTAL(3,$B$2:$B2)
4. Copy the formula down to all rows of data
5. Select the worksheet
6. Choose Format>Conditional Formatting
7. Choose Formula Is
8. In the formula box, type:
=AND($A1<>"",MOD($A1,2)=0)
9. Click the Format button, and select a colour for the shaded rows
10. Click OK, click OK

Filter the table, the count will change, and alternate rows will be shaded.
========================================================

I tested it myself and it seems to work, hopefully it does for you. (You can hide the helper column, too.)

[VBA Noob]

Hi,

Use a helper column. Enter this in say B1 and drag down.

=MOD(SUBTOTAL(3,$A$1:$A1),2)


Then do your CF on the 1's or 0's

VBA Noob