Compare field in first record to same field in next record
I want to:
- Go to a field in the first record in the layout
- Compare that field to the same field in the next record
- If the field values match, color first field and matching field the same color (yellow)
- Have the script continue until field does not match prior field
- Loop and repeat the process, beginning with the new field value
How can this be done?