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.

Had that qsame uestion a day or so ago. You need to use format conditional
formating. It is very simple. can make the text bold, put aborder around it
or make ti a color. Look in forum on excel.programing on the 17th topic New
and exciting things, go tehre and see replys to mine.

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

One way:

Setup Conditional formatting for the cell or column that should change color
when a date is entered.
Select the cell or column. Goto Format-Conditional Formatting.
Click drop-down and select ' Formula Is'. Then use this formula.

=NOT(ISERROR(DATE(YEAR(A1),MONTH(A1),DAY(A1))))

Set your format for whatever color you want (click Format button, select
Patterns and then the color you want.).
There are probably other formulas that would work, but this seems to do the
trick.

HTH,
Paul


"bollard" wrote in message
...
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.

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.

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.