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.

On Nov 19, 11:04*am, RedBeard wrote:
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.

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?

--
Rick (MVP - Excel)


"RedBeard" wrote in message
...
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.

On Nov 19, 5:21*pm, "Rick Rothstein"
wrote:
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?

--
Rick (MVP - Excel)

"RedBeard" wrote in message

...

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.

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 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" wrote:

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.
.

On Nov 19, 6:03*pm, Matthew Herbert
wrote:
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" wrote:
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.
.

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" wrote:

On Nov 19, 6:03 pm, Matthew Herbert
wrote:
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" wrote:
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.
.

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

On Nov 20, 10:26*pm, Matthew Herbert
wrote:
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" wrote:
On Nov 19, 6:03 pm, Matthew Herbert
wrote:
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" wrote:
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.
.

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

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?