I have a row where I have dates of the month - C2:AG2. I want a formula,
where if I enter a text in the corresponding row, and if the date is not
todays date, it shud not allow me to enter text.
Cl 1 Cl 2 Cl 3 Cl 4 Cl 14 Cl 15
Cl 16
Eg: Row A - 1 apr 2 apr 3 apr 4 apr ..... 14 apr 15 apr 16 apr
Row B - P

Now if I try to enter a value in row B, it shud not allow as the date is not
today date. I shud be able to enter value only if the date corresponds to
todays date.

Is this possible, Pls help !!!!! Hope I've made my question clear.

Nemo wrote:
I have a row where I have dates of the month - C2:AG2. I want a formula,
where if I enter a text in the corresponding row, and if the date is not
todays date, it shud not allow me to enter text.
Cl 1 Cl 2 Cl 3 Cl 4 Cl 14 Cl 15
Cl 16
Eg: Row A - 1 apr 2 apr 3 apr 4 apr ..... 14 apr 15 apr 16 apr
Row B - P

Now if I try to enter a value in row B, it shud not allow as the date is not
today date. I shud be able to enter value only if the date corresponds to
todays date.

Is this possible, Pls help !!!!! Hope I've made my question clear.


First, rows are numbered, columns have letters. Getting that right would make
your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3 through 10,
select C3:AG10 and select Data / Validation. On the Settings tab, for Allow
select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.

Glenn wrote:
Nemo wrote:
I have a row where I have dates of the month - C2:AG2. I want a
formula, where if I enter a text in the corresponding row, and if the
date is not todays date, it shud not allow me to enter text.
Cl 1 Cl 2 Cl 3 Cl 4 Cl 14 Cl
15 Cl 16
Eg: Row A - 1 apr 2 apr 3 apr 4 apr ..... 14 apr 15 apr 16 apr
Row B - P
Now if I try to enter a value in row B, it shud not allow as the
date is not today date. I shud be able to enter value only if the date
corresponds to todays date.

Is this possible, Pls help !!!!! Hope I've made my question clear.


First, rows are numbered, columns have letters. Getting that right
would make your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3
through 10, select C3:AG10 and select Data / Validation. On the
Settings tab, for Allow select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.

Sorry, should be this:

=C$2=TODAY()

It worked, Thanks a ton !!!!

"Glenn" wrote:

Glenn wrote:
Nemo wrote:
I have a row where I have dates of the month - C2:AG2. I want a
formula, where if I enter a text in the corresponding row, and if the
date is not todays date, it shud not allow me to enter text.
Cl 1 Cl 2 Cl 3 Cl 4 Cl 14 Cl
15 Cl 16
Eg: Row A - 1 apr 2 apr 3 apr 4 apr ..... 14 apr 15 apr 16 apr
Row B - P
Now if I try to enter a value in row B, it shud not allow as the
date is not today date. I shud be able to enter value only if the date
corresponds to todays date.

Is this possible, Pls help !!!!! Hope I've made my question clear.


First, rows are numbered, columns have letters. Getting that right
would make your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3
through 10, select C3:AG10 and select Data / Validation. On the
Settings tab, for Allow select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.

Sorry, should be this:

=C$2=TODAY()
.

You're welcome!

Nemo wrote:
It worked, Thanks a ton !!!!

"Glenn" wrote:

Glenn wrote:
Nemo wrote:
I have a row where I have dates of the month - C2:AG2. I want a
formula, where if I enter a text in the corresponding row, and if the
date is not todays date, it shud not allow me to enter text.
Cl 1 Cl 2 Cl 3 Cl 4 Cl 14 Cl
15 Cl 16
Eg: Row A - 1 apr 2 apr 3 apr 4 apr ..... 14 apr 15 apr 16 apr
Row B - P
Now if I try to enter a value in row B, it shud not allow as the
date is not today date. I shud be able to enter value only if the date
corresponds to todays date.

Is this possible, Pls help !!!!! Hope I've made my question clear.

First, rows are numbered, columns have letters. Getting that right
would make your question more clear.

Look at Data Validation. Assuming you want this behavior in rows 3
through 10, select C3:AG10 and select Data / Validation. On the
Settings tab, for Allow select Custom and for Formula enter the following:

=C2=TODAY()

Fill in the Input Message and Error Alert tabs as desired and click OK.
Sorry, should be this:

=C$2=TODAY()
.