Workaround of Alternate row color will run throughout the excel when exported

When Crystal Report is Exported to EXCEL. Alternate row color will run through out the excel as show in Screen Shots.

Workaround:

1. Instead of giving background color to detail section as shown in the screenshot.

          if (RecordNumber mod 2)=0 Then crSilver else crNoColor

2. Give the background color for each variable as shown in the screen shot with the formula

               if (RecordNumber mod 2)=0 Then crSilver else crNoColor

3. After exported to excel looks as shown in the screen shot.