Conditional Formatting

=($D2-$C2)=MAX($D2:$D$6-$C$2:$C$6)


"abcd" wrote:

want to highlight the NAMES OF THE STUDENTS who have got more marks in the
TEST than PRE-TEST ?
Eg:
Student name Pre-test Test
A O 89 93
B P 91 90
C Q 75 81
D R 65 65
E S 90 81