Continuous forms

Say if i have a field in a continuous form of random number long so Part a may have 4 rows of data and b may have 5 rows of data. How do you indepently work with each row.

Example

Name Age
Matt 15
Matt 16
Matt 15

Another example

Name Age
Bill 14
Bill 15

So If i wanted to scroll through names and a list of ages for all people with that name appeared and i wanted to highlight all the 14s red and 15s green how can i do that without conditional formatting. Want to use VBA

Thanks for the help

Re: Continuous forms

yeah i realized that it was hard to understand just wanted to set up a senario. Yeah I just did conditional formatting