I am creating an action plan in excel 2003 and I want to use conditional
formatting to format the row once a cell in the action status column reads
"Completed".

I can use Conditional Formatting to format the cell containing "Completed"
however I don't know what to do to apply this formatting to the rest of the
row in the range.

Can anyone help me with this!

Cheers
Kate