Show cell contents depending on other cells information

[RedBeard]

Hello, here is my problem.

I have two cells (B5) and (C5).

If (B5) has any other value than 40 or if (C5) contains text, I want
to display the contents of cell (D5).
Otherwise the contents of (D5) are to remain invisible.

Is this doable?

Thanks.

 

[jason]

Hello, here is my problem.

I have two cells (B5) and (C5).

If (B5) has any other value than 40 or if (C5) contains text, I want
to display the contents of cell (D5).
Otherwise the contents of (D5) are to remain invisible.

Is this doable?

Thanks.

=or(if(b5<>40,D5,"#N/A),if...)

then do a conditional formatting. do you mean invisible or blank?
if invisible do conditional formatting, if blank change #N/A to
nothing.

 

[Rick Rothstein]

What is in D5... a formula or a typed in value? If a typed in value, will it
ever be changed by the user of the worksheet?

 

[Matthew Herbert]

RedBeard,

Are you saying that D5 will contain it's current value or blank data? If
the value needs to end up in D5 then you might need to put column D data into
column E and use the following (which is in cell D5):
=IF(OR(B5<>40,ISTEXT(C5)),E5,""); otherwise the D5 formula will need to hard
code the D5 value and put it where "E5" is in the formula above.

Genral Formula
=IF(OR(B5<>40,ISTEXT(C5)),D5,"")

Best,

Matthew Herbert

 

[RedBeard]

What is in D5... a formula or a typed in value? If a typed in value, willit
ever be changed by the user of the worksheet?

It is a string of text that will not be changed.

 

[RedBeard]

RedBeard,

Are you saying that D5 will contain it's current value or blank data?  If
the value needs to end up in D5 then you might need to put column D data into
column E and use the following (which is in cell D5):
=IF(OR(B5<>40,ISTEXT(C5)),E5,""); otherwise the D5 formula will need tohard
code the D5 value and put it where "E5" is in the formula above.

Genral Formula
=IF(OR(B5<>40,ISTEXT(C5)),D5,"")

Best,

Matthew Herbert

D5 will either have it's contents visible or invisible, it is a string
of text that does not change.

 

[Matthew Herbert]

RedBeard,

Are you still looking for an answer, or did the posts answer your question?
If the posts didn't answer your question, can you provide more detail as to
what isn't working (e.g. the formula isn't working, the formula is fine but
the D5 value needs to be embedded in the formula, etc)?

Best,

Matt

 

[RedBeard]

RedBeard,

Are you still looking for an answer, or did the posts answer your question?  
If the posts didn't answer your question, can you provide more detail as to
what isn't working (e.g. the formula isn't working, the formula is fine but
the D5 value needs to be embedded in the formula, etc)?

Best,

Matt

Matthew,

Thank you for the followup.
I have been experimenting with the solution you provided, but I can't
get it to work and I don't really understand why.

I put =IF(OR(B5<>40,ISTEXT(C5)),D5="test","") in the conditional
formatting field with a range of $B$5:$D$5.

Any ideas?