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