Thursday, November 1, 2007

How to use conditional formatting

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: