Color every other group of 3 lines in the detail section 1

[JStrittmatter]

I am using CR9
I want to be able to color every other group of 3 lines in the detail section.
I know that there has to be a formula out there that can help me with this.
Please see the example.

[COLOR=black silver]
line 1
line 2
line 3[/color]
line 4
line 5
line 6[COLOR=black silver]
line 7
line 8
line 9
[/color]

 

[mbarron]

Go to format/Section... On the Color Tab click on the conditional format (x-2) button.

In the formula box use
if remainder(recordnumber-1,6)<3 then silver else defaultattribute



Mike

 

[JStrittmatter]

Mike,

Thanks a lot It worked wonderfully!!!

Justin