Alternate row color in details section 1

[ssudha]

Hi All,

How to give a background color to the alternate row in the details section? Any formula will be greatly appreciated.

Thanks in advance.

 

[mbarron]

Go to Format/Section... Choose the Details. On the color tab, click the (x-2) button for the background and use:

if remainder(recordnumber,2)=1 then silver else defaultattribute

If you want to alternate every three row (or any other number) (change the numbers in blue) use:
if remainder(recordnumber,6) in 1 to 3 then silver else defaultattribute Mike

 

[ssudha]

Thanks Mike. The formula worked and saved a lot of time for me.

Regards,
Sudha

 

[aloittelija]

Found this formula really usefull and not just coloring the rows!

Great hint! Thanks!