have a table "seat_master" having fields with regno,name,dob,caste,merit,rank, having 16 records. I have a form "pec_display.scx" in that i placed a grid and set its recordsource is seat_master.

my question is i want highlight the grid row color, when i run the form( record from 1 to 4 is Yellow color and record 5 to 8 is Blue in color and record 9 to 12 is green in color and record from 13 to 16 is orange in color).

How to do this?