AS a teacher I have two columns - 1 with childrens names the 2nd cloumn has
scores.

I want to be able to extract those children by name who have scored within a
range of marks or < a mark or scored a set mark etc and have this shown in a
report or area of the spreadsheet.

Possible?

ALSO can those children who meet the criteria have the original cells with
their 2 columns automatically change colour ? as a way of highlighting them?

Thanks
for your assistance
Mike