Hi Jason thanks for the response,
With a little playing around I managed to get it to work and may I say add an else to the code. lol
<td<?php if ($row_Recordsetliveengineers['jobcompleted'] == "Yes") echo" bgcolor=\"#00FF00\"" ; else if ($row_Recordsetliveengineers['jobcompleted'] == "No") echo" bgcolor=\"#FF0000\""?>></td>
A big thanks again
john