Hi Joe,

Use conditional formatting with a formula condition like:

=MOD(ROW(),2)=0


---
Regards,
Norman



"Joe who?" wrote in message
news:_kL_e.280372$Hk.96115@pd7tw1no...
Looking at a large spread sheet full of data can become hard on the eyes.
Is there a way to alternate the colors or shading of each row permanenatly
so the shading does not move or change once the rows of data are moved or
sorted ?

Many thanks