Noz

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

This one will retain the banding when you filter the data.

=MOD(ROW(),2)=0 will not retain the banding through filtering.


Gord Dibben MS Excel MVP

On Thu, 22 May 2008 06:18:22 +0100, Nozza wrote:

In article , Mike
H said...

Hi,

You could do it with a macro but by far the simplest is to select your range
then

When I see a phrase like "by far the simplest..." I usually think
"Here we go again" ;)

Format|Conditional format | Formula is
Paste in this formula
=MOD(ROW(),2)=0
select a colour and click OK

Good Grief!

That really is simple - *and* for once I understand why it works!

This ones a keeper.

Thanks for the reply

Noz