Formatting cell

[Guest]

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

 

[Guest]

assuming the name is in Column A
you need something like
=IF(A2>1,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