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).

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

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).

I am just a beginner, what goes between the < and the ""?

"Dave Peterson" wrote:

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

I am just a beginner, what goes between the < and the ""?

Nothing.

< is an operator that means: is not equal to

"" is the syntax for an empty string which means "blank".

So: =$z1<""

Is a simple test that will return either TRUE or FALSE. In plain English it
means: Z1 is not equal to blank.

When that test is TRUE then the formatting is applied. When that test is
FALSE the formatting is not applied.

--
Biff
Microsoft Excel MVP


"Bob Luck" wrote in message
...
I am just a beginner, what goes between the < and the ""?

"Dave Peterson" wrote:

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