Thanks Nadya,
that got my brain going. I got what I wanted with this:
iif(inlist(mod(recno(),8) 1, 2, 3, 4), GreenColor, RedColor)
>>Hi,
>>
>>I have a grid which is displaying information like this:
>>
>>Age 5yrs 10yrs 20yrs
>>50 1235 1345 7676576
>>50 3234 54365 658678
>>50 87668 87699 768898
>>50 76576 65767 09809
>>55 876987 090980 09809
>>55 765876 989878 768767
>>55 876876 785457 6757687
>>55 654655 435354 6546565
>>60...
>>
>>and so on, in groups of 4 records per each age.
>>
>>I want to highlight alternating groups to make it easier to read. What formula can i use to do this?
>>
>>Thanks.
>
>From the top of my head:
>
>iif(mod(recno(),8) <5, GreenColor, RedColor)