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