Cell Validation

[Duncs]

I need to utilise some form of validation on the data that is entered
in various cells
in my Excel 2003 spreadsheet.

1. In date cells, the following validation should exist:
a. The date should be in the format dd/mm/yyyy
- I've set the cell format to Date, dd/mm/yyyy which I believe
will achieve
this
b. The date should be greater than 01/10/2008
- I've used Data|Validation and set the validation criteria to:
Date, Greater than, 01/10/2008
c. The date should not be greater than today's date
- Not sure on how to achieve this. I've played around with the
validation
criteria settings, but nothing seems to work
2. There are cells that take a Yes/No value:
a. Where a cell has a 'Yes' value, certain cells after this cell
must have data
entered
b. Where a cell has a 'No' value, certain cells after this cell
must not have
data entered

Can anyone suggest how to do this?

TIA

Duncs

 

[Jim Rech]

Re the date validation enter =TODAY() as the End Date in the Data Validation
dialog after selecting Date and."between"

--
Jim
|I need to utilise some form of validation on the data that is entered
| in various cells
| in my Excel 2003 spreadsheet.
|
| 1. In date cells, the following validation should exist:
| a. The date should be in the format dd/mm/yyyy
| - I've set the cell format to Date, dd/mm/yyyy which I believe
| will achieve
| this
| b. The date should be greater than 01/10/2008
| - I've used Data|Validation and set the validation criteria to:
| Date, Greater than, 01/10/2008
| c. The date should not be greater than today's date
| - Not sure on how to achieve this. I've played around with the
| validation
| criteria settings, but nothing seems to work
| 2. There are cells that take a Yes/No value:
| a. Where a cell has a 'Yes' value, certain cells after this cell
| must have data
| entered
| b. Where a cell has a 'No' value, certain cells after this cell
| must not have
| data entered
|
| Can anyone suggest how to do this?
|
| TIA
|
| Duncs

 

[Duncs]

Jim,

Thanks for that. I was trying to over complictae that bit, by
referring to a cell that contained the formula =TODAY().

Once again thanks

Duncs