How to use conditional formatting
a)-Choose the FORMAT, click CONDITIONAL FORMATTING

b)-You will see the conditional formatting dialog box

c)-set the format of the cell

d)- The result is like below, one person failed, because this person less then 60 marks.

No comments:
Post a Comment