Try this conditional format formula, taken from a post by Tom Ogilvy,
http://tinyurl.com/dsu87

" If the hidden rows are cause by applying a filter
then this formula will work:

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

Select the rows to format (this assumes the formatting starts with row 1)
Enter the formula as if it were for the the currently active cell (in this
case A1). The range must be applied to a column that will contain values in
each visible cell in the column. "

The formula above will also take care of the normal unfiltered situation
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Conditional Format Issue" wrote:
I'm filtering results of a table and want to have alternating rows filled
with a color even as I'm filtering and unfiltering results. In other words, I
want alternating colors no matter which rows are in view at any given point.
Any ideas? Thanks.