Hi

I have a spreadsheet listing work items one one column and the due data due
another column. Once the work is completed the complettion date is entered
in a third column.

What i need is to condtionally format the data so that if the work is
completed before the due date all the data in the whole row goes one colour
and if the completion date exceeds the due date the data in the whole row
goes a different colour.

The conditional formating rules only seem to allow me to change colour of
the data in one cell, i.e.

Is there a way to conditonally format the whole row based on the data in one
cell?

Thanks