In Cells A1, I am entering the day of the month.

Depending on the value of A1, I want it to mark an X on one of cells B1 to
B31.

e.g. if A1 is the 20th day of the month, I want it to automatically mark
cell B20 with an X.

How do I do that?

Thanks.

one way:

B1: =IF($A$1=ROW(), "X","")

Copy down to B31.


In article ,
"Ed" wrote:

In Cells A1, I am entering the day of the month.

Depending on the value of A1, I want it to mark an X on one of cells B1 to
B31.

e.g. if A1 is the 20th day of the month, I want it to automatically mark
cell B20 with an X.

How do I do that?

Thanks.

Thanks all for your quick replies! All solutions worked out great.

Now, suppose I expand on this. In Cell A2, it indicates the day which is an
OFF DAY.

Then, depending on the value of A2, I want to mark a "Y" on one of the cells
from B1 to B31.

How would I combine the solution from before with this one?

Can I do something like this?
B1: =IF($A$1=ROW(), "X","") or IF($B$1=ROW(), "Y","")

Hi Ed
try
=IF($A$1=ROW(), "X",IF($B$1=ROW(), "Y",""))

Frank

Ed wrote:
Thanks all for your quick replies! All solutions worked out great.

Now, suppose I expand on this. In Cell A2, it indicates the day
which is an OFF DAY.

Then, depending on the value of A2, I want to mark a "Y" on one of
the cells from B1 to B31.

How would I combine the solution from before with this one?

Can I do something like this?
B1: =IF($A$1=ROW(), "X","") or IF($B$1=ROW(), "Y","")

=Trim(if($A$1=Row(),"X","") & " " & if($A$2=row(),"Y",""))

--
Regards,
Tom Ogilvy

Ed wrote in message
...
Thanks all for your quick replies! All solutions worked out great.

Now, suppose I expand on this. In Cell A2, it indicates the day which is
an
OFF DAY.

Then, depending on the value of A2, I want to mark a "Y" on one of the
cells
from B1 to B31.

How would I combine the solution from before with this one?

Can I do something like this?
B1: =IF($A$1=ROW(), "X","") or IF($B$1=ROW(), "Y","")

Just to point out the difference, if A2=A1, Fred's would put an X, while
mine would put X Y

You didn't specify what you wanted in this situation (or if that was
something that could happen).

--
Regards,
Tom Ogilvy

Tom Ogilvy wrote in message
...
=Trim(if($A$1=Row(),"X","") & " " & if($A$2=row(),"Y",""))

--
Regards,
Tom Ogilvy

Ed wrote in message
...
Thanks all for your quick replies! All solutions worked out great.

Now, suppose I expand on this. In Cell A2, it indicates the day which
is
an
OFF DAY.

Then, depending on the value of A2, I want to mark a "Y" on one of the
cells
from B1 to B31.

How would I combine the solution from before with this one?

Can I do something like this?
B1: =IF($A$1=ROW(), "X","") or IF($B$1=ROW(), "Y","")

In cell B1 type

=IF(DAY($A$1)=ROW(B1),"X","")

Copy it to the range B1 to B31.


"Ed" wrote in message
...
In Cells A1, I am entering the day of the month.

Depending on the value of A1, I want it to mark an X on one of cells B1 to
B31.

e.g. if A1 is the 20th day of the month, I want it to automatically mark
cell B20 with an X.

How do I do that?

Thanks.

Sub markit()
Cells(Day(Cells(1, 1)), 2) = "X"
End Sub


-----Original Message-----
In Cells A1, I am entering the day of the month.

Depending on the value of A1, I want it to mark an X on
one of cells B1 to
B31.

e.g. if A1 is the 20th day of the month, I want it to
automatically mark
cell B20 with an X.

How do I do that?

Thanks.


.