I have used excel to prepare a mark sheet thus:

Name
Mark Grade Remarks
Mr x 80 1 Distinction
Mr y 30 9 Fail
Mr z 65 3 Credit
9 Fail
9 Fail
9 Fail
9 Fail

Because of the IF function used for the grade and remarks columns, they
output "9" and "Fail" respectively even when there were no names.
Please is there any way I can
First have a function that would allow the name, mark, grade and remark
colum to be empty UNLESS when data is input into them?
Second, what function can I use for changing the colour of the remark
depending on the output. For example, red for a student that failed.
thanks,
bimseun