Unlock Cells on Condations

[Selva]

Hi,

I need some assistance in unlocking a range of cells based on date
conditions

For example, B1:B32 has dates for the month and based on today's date,
it should unlock the entire column to allow the user to enter the
data.

It should not allow the user to enter data for yesterday or
tomorrow.......

Cell should be open only for today's date.

 

[Billy Liddel]

You can try Data Validation.

Allow: Date
Data: equal to
Date: =Today()

Remember that you can still drag and fill a range of date or copy a data
that does not meet the criterion.

Encourage users to enter the Date using Ctrl + ;

HTH
Peter

 

[Selva]

Hi Peter,

Thanks for your suggestion. I want to enter some data in the range
based on the date.


1/15 1/16 1/17
1/18 1/19 1/20

XXX

As per above example, the data should be allowed to enter for today's
date.

Can you check this.

Thanks once again.