Wanting a cell to be blank unless info in another cell

[FYRGUY47]

HI,
I am using Excel 2002. I have used this site before a couple of years ago and have found it to be very, very helpfull. Here is my latest delema.. Thank you in advance.

Problem 1:
Cell B3 is formatted as a date mm/dd/yy. I would like it to add 45 days to a date entry which will be in cell B2 also formatted as a date. However if no date is in B2 then I would like B3 to remain blank.

Problem 2:
In cell B2 (same as above)I have the word "date" inside the cell shaded in grey to assist with entry. If someone enters a date in that cell, can the text change color to black. Would that be a conditional format?

Thanks Chris

 

[MattGreer]

Problem 1:

Put this formula in cell B2:

=if(B3="","",=B3+45)

You'll have to have B2 formatted as a date, however.

Problem 2:

Yes, conditional formatting.

Thanks!!


Matt

 

[MattGreer]

Oops, take the equals sign out of that formula insides the parens.

Thanks!!


Matt

 

[FYRGUY47]

Thank you Matt!

B2 is formatted as a date, so I will put that formula in!

I tried to do the conditional format after I posted, however haven't had any luck. Any help there would be appriciated.

Chris

 

[FYRGUY47]

Matt, your fix works perfectly, however I didn't do a good job explaining.

My origninal post stated the cell will be blank. I guess it wont be because I was going to have "date" in that cell shadded to help the end user. Thus problem #1 & #2 are the same cell. So, if possible, can cell B2 have text ("date")in the cell and B3 still be blank unless a actual date is entered. And when that date is entered, the shadded "date" text will change to a black colored date.

I hope this makes since

Chris

 

[SkipVought]

[tt]
B3: =if(B2="DATE","",B2+45)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[FYRGUY47]

Thank you Skip.

After a while most of this makes since. Thanks