software

I have used excel to prepare a mark sheet thus:

Name
MarkGradeRemarks
Mr x801Distinction
Mr y309Fail
Mr z653Credit
9 Fail
9 Fail
9 Fail
9 Fail

Because of the IF function used for the grade and remarks columns, they
output quot;9quot; and quot;Failquot; 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,
bimseunassuming the name is in Column A
you need something like
=IF(A2gt;1,IF FORMULA,quot;quot;)
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 criteriaquot;bimseunquot; wrote:

gt; I have used excel to prepare a mark sheet thus:
gt;
gt; Name
gt; MarkGradeRemarks
gt; Mr x801Distinction
gt; Mr y309Fail
gt; Mr z653Credit
gt; 9 Fail
gt; 9 Fail
gt; 9 Fail
gt; 9 Fail
gt;
gt; Because of the IF function used for the grade and remarks columns, they
gt; output quot;9quot; and quot;Failquot; respectively even when there were no names.
gt; Please is there any way I can
gt; First have a function that would allow the name, mark, grade and remark
gt; colum to be empty UNLESS when data is input into them?
gt; Second, what function can I use for changing the colour of the remark
gt; depending on the output. For example, red for a student that failed.
gt; thanks,
gt; bimseun
gt;
gt;
gt;
gt;