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

You do not want to fill an entire row with a color!

That would fill 256 columns with color in 2003 and earlier versions and
16384 columns in version 2007. If user prints, they are going to get a whole
lot of pages with nothing but a colored column/line

Instead, name the range and fill only the range



"PRS1114" wrote:

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

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