Excel 2007 : Format previous cell based on current cell

Hi,

Use conditional formatting. Create two Cond. formats

=A3="Absent"

set the colour to red and apply it to A$3:A$13
Do the same with the second Cond. format

=A3="Present"

and colour it green.

Regards