See original thread

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Philip J Smith" wrote in message
...
Hi Bollard

Try this with conditional formatting.

You need to test for cell content i.e not blank and for a date, this
latter
indirectly by checking the format.

1. Select the cell which you want to format say A2 and test row 2
2. Click on the Format menu.
3. Select conditional formatting
4. In the first drop down box select Formula is
5. Assuming that the data to be tested is in column D type the following
in
the long box to the right.
=IF(AND(LEFT(CELL("Format",D2),1)="D",ISBLANK(D2)= FALSE),1,0)
6. Click on the Format. button.
7. The select the Patterns Tab of the dialogue box
8. Choose your colour and click OK
9. Then Click OK on the Conditional Formatting Dialogue Box

Regards
Phil

"bollard" wrote:

In a spreadsheet, we want one field in a row to turn grey if a date is
entered into another field along that column, otherwise it retains the
colour
it started with.

Any ideas?

Thanks.