how to use conditional formatting
 

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

how to use conditional formatting
 

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

how to use conditional formatting
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"abcd" wrote in message
...
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