If greyed out means to apply shading to that row, you could use conditional
formatting.

If your rightmost column is column Z, then select your range (A1:Z99)

And with the activecell in row 1:
formula is:
=$z1<""
and give it a nice grey pattern.

(xl2003 menus)


Bob Luck wrote:

I am trying to set up a spreadsheet wherein the far right column is the date
of completion of a particular task. I would like to have that row be
automatically grayed out when the field is populated with the date of
completion (far right column).

--

Dave Peterson