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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top