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

[Former Member]

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.