View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default Shaded every second row Please

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.