Shaded every second row Please

S

Steved

Hello from Steved.

I've forgotten how to shade every second row.

Please explain how I can do this.

Thankyou.
 
N

N Harkawat

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
 
S

Steved

Excellent and thankyou.

N Harkawat said:
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
Click to expand...
 
Top