Show cell contents depending on other cells information

  • Thread starter Thread starter RedBeard
  • Start date Start date
R

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.
 
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.
Click to expand...

=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.
 
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?
 
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
 
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?
Click to expand...

It is a string of text that will not be changed.
 
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
Click to expand...

D5 will either have it's contents visible or invisible, it is a string
of text that does not change.
 
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,

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
Click to expand...

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?
 
Back
Top