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.