Thanks for confirming, Gord.

I suspect the OP didn't apply it correctly.

--
Biff
Microsoft Excel MVP


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Works as advertised in 2003 version.


Gord Dibben MS Excel MVP

On Mon, 15 Oct 2007 14:34:09 -0400, "T. Valko"
wrote:

I don't have Excel 2003 to test this.

I have Excel 2002 and that is the same basic formula I'd use to color band
a
filtered list. In Excel 2003 they modified the SUBTOTAL function to
include
hidden rows. The 103 in the formula means to account for hidden rows.

Try reposting your question in a new thread.