Hello, i am new to filemaker. i am working on a test report of students. The tables are based on the test result of a student.
The report structures like this
(Body) A B C Total(A + B + C)
1. 40 50 60 150
2. 50 70 80 200
1. 50 65 70 185
2. 51 56 80 187
a student could take as many tests as they could.
i would like to use conditional formatting to highlight the test with the highest score.
What should i do? could i highlight the related records only.
I am using filemaker 15