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