Please Help Wth Cell shading
 

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

Please Help Wth Cell shading
 

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

Please Help Wth Cell shading
 

That's great Norman, I'll give it a try. thanks for the help !


"Norman Jones" wrote in message
...
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