school result sheet problem

Dear mate

i want to enter "ABSENT" text in the cell of subject marks. i mean

1.when i enter less than 50 marks. the cell color should be automatically changed

2.if i enter no marks in that cell then ABSENT should be entered automatically and there should not be any problem in obtained marks.

thanx

plz check attached file