Invert color from gray to white in the details

Anyone has a quick formula that will display the Details of a certain group header with 2 colors, alternating each other?
I want the odd's to be in white and the even's to be in gray (or something like it).
My formula dosn't work, and I'm not sure what to use for it.

Thanks,

Gian
gian_the_manAsked:
Who is Participating?
 
mlmccCommented:
What are you trying?

Click FORMAT --> FORMAT SECTION
Select the approprite detail section
Click the Color Tab
Click the formula button for background
If (RecordNumber mod 2) = 0 then
  gray
else
  white

mlmcc
0
 
frodomanCommented:
If Remainder(GroupNumber, 2) = 0 Then
   gray
Else
   white
0
 
frodomanCommented:
Or

If (GroupNumber Mod 2) = 0 Then
   gray
Else
   white

I think this is actually marginally faster because it does integer math instead of real numbers.
0
 
mlmccCommented:
Glad I could help

mlmcc
0
 
gian_the_manAuthor Commented:
You are the man...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.