Date value entered to cell

[Dougie1]

Hi all,

Using Excel 2007.

I would like to generate a warning if the date entered into cell A2 does not equal yesterday's date. I don't want to prevent that date being entered by any means, I would just like to be able to alert the inputter that they have not entered yesterday's date and ask if they wish to proceed with the date that they have entered - YES or NO.

I know I could use data validation to prevent any date but yesterday's being entered into A2, but as I said, I don't want to restrict input, I only want to alert.

Is this possible?

All help gratefully received.

TIA

D

 

[GK039]

Hi

Use Data Validation and under the Error Alert tab choose Style:Information with an appropriate error message

George

Hi all,

Using Excel 2007.

I would like to generate a warning if the date entered into cell A2 does not equal yesterday's date. I don't want to prevent that date being entered by any means, I would just like to be able to alert the inputter that they have not entered yesterday's date and ask if they wish to proceed with the date that they have entered - YES or NO.

I know I could use data validation to prevent any date but yesterday's being entered into A2, but as I said, I don't want to restrict input, I only want to alert.

Is this possible?

All help gratefully received.

TIA

D

 

[Dougie1]

Thanks GK039

Can you be more specific ?? i.e. how do I set the validation to generate a message but without restricting input ??

TIA

 

[number kruncher]

Hi all,

I know I could use data validation to prevent any date but yesterday's being entered into A2, but as I said, I don't want to restrict input, I only want to alert.

D

If all you need is an alert but no restrictions, you could have an adjacent cell to the input cell test the entered amount, to test it's validity, with Conditional Formating, to either show or not.

e.g. =IF(A1>5,"Value to High","")

 

[GK039]

You're welcome

1) Open Data Validation dialog box
2) In the settings tab in the allow list choose Date then in the Data dialog box choose equal to and in the last dialog box named Date: place the following formula

=today()-1

3) In the input message tab place a message indicating the kind of information that should be entered and
4) in the last tab Error Alert there is a drop down menu with 3 choices a)Stop b) Warning c) Information

Choose information and you will have what you want

Thanks GK039

Can you be more specific ??

 

[Dougie1]

Thanks GK039 - but that will not allow any date rather than TODAY()-1 to be entered and that is not what I am after.

 

[GK039]

Try it again
It does allow any value, even text. Make sure you have selected the Information style in the error tab

George

Thanks GK039 - but that will not allow any date rather than TODAY()-1 to be entered and that is not what I am after.

 

[Dougie1]

Please accept my most humble apologies GK039 - that works perfectly.

Thanks again

D

 

[GK039]

You' re welcome

Please accept my most humble apologies GK039 - that works perfectly.

Thanks again

D