Let's assume your data are in range A2:G10 and the completion dates are
entered in column E.

1) Select range A2:G10
2) From menu select Format = Conditional Formatting
3) For Condition1 select 'Formula is'and type in the formula
"=NOT(ISBLANK($E2))" without the quotes.
4) Set the format for this condition as needed (in your case select a gray
cell shading)
5) Press 'OK'

Now whenever a value is entered into a cell of column E, the whole row (up
to column G) turns gray.

Hope that this is what you want to achieve.

Cheers,

Joerg Mochikun




"PRS1114" wrote in message
...
I have a spreadsheet where I log certain tasks to be completed and their
due
dates. I would like to set up conditional formatting to fill the entire
row
with a gray color once the job have been completed. I have a column that
has
a completion date that is filled in by which ever person completed the
task.
Is there a way to make the entire row fill once a value has been entered
into
one cell and if so, how do I do that? Any help would be appreciated.
Thank
you.
--
PRS1114