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

assuming the name is in Column A
you need something like
=IF(A21,IF FORMULA,"")
where you replace IF FORMULA with your current one.

and same with the remark column

re. colour of remark.

Select the column and select conditional formatting. and set the criteria


"bimseun" wrote:

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