How about Conditional Formatting?

Select the range to gray out then FormatCFFormula is:

=$M1<"" Format to light gray.

Assumes column M is date of completion. Adjust to suit.


Gord Dibben MS Excel MVP

On Sat, 30 Aug 2008 08:13:01 -0700, Bob Luck <Bob
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).