>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)
If it's not broken, fix it until it is.
My Blog