Hello from Steved.

I've forgotten how to shade every second row.

Please explain how I can do this.

Thankyou.

press control a
then format conditional formating and select formula is and type
=MOD(ROW(),2)=1
click format and then pattern and select the desired color

"Steved" wrote in message
...
Hello from Steved.

I've forgotten how to shade every second row.

Please explain how I can do this.

Thankyou.

Excellent and thankyou.

"N Harkawat" wrote:

press control a
then format conditional formating and select formula is and type
=MOD(ROW(),2)=1
click format and then pattern and select the desired color

"Steved" wrote in message
...
Hello from Steved.

I've forgotten how to shade every second row.

Please explain how I can do this.

Thankyou.