how to use conditional formatting

A

abcd

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
 
B

Bernard Liengme

Assuming names in A2 to A100 (or what ever) and pretest in B with test in C
Select A1:C100
Conditional Formatting: Formula Is: =$C2>$B2
best wishes
 
Top