Hi all i wish to change the colour of a particular row within a table view.

In each row there is a field which is marked either as completed (Yes) or not completed (No). If the record is marked as not complete I wish for the row to be colour red. If the row is marked as complete I want the row to coloured green.

Thanks for your time and trouble