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.