Automatically gray out a row when a particular field is populated

[Bob Luck]

I am trying to set up a spreadsheet in Excel 2003 wherein the far right
column is the date of completion of a particular task. I would like to
automatically gray out the row when the far right cell in the row is
populated with the date of completion of the task.

 

[Dave Peterson]

Check your previous post.

I am trying to set up a spreadsheet in Excel 2003 wherein the far right
column is the date of completion of a particular task. I would like to
automatically gray out the row when the far right cell in the row is
populated with the date of completion of the task.