Hide the content of a cell

[Teuchter029]

Good evening all

I have attached an extract from my workbook.

I would like to hide the content of a cell based on the value from an If statement in another cell

B52 contains an if statement with conditional formatting. The value can either be "No - Privately funded" or "Yes - Funded as Normal with the Reduction Indicated"

If the value of B52 is "No........" then I would like the content of B54 to be visible and if "Yes.........." then not.

Any help would be great!

[Fluff13]

Select B54 & in conditional formatting, new rule, use a formula & use

Please Login or Register  to view this content.

[Teuchter029]

Thank you very much Fluff13

I must be doing something wrong it is not working!

I have clicked on B54 and gone to Conditional Formatting - New Rule - Use a formula to determine........ and pasted =LEFT(B52,2)="no" into the Format values where....... area and then clicked ok.

[Fluff13]

Forgot to say change the CF font to white.

[Teuchter029]

Thank you very much.

It works, but the opposite to what I require. If it is "no" I need to see the content of of B54 and if "yes" then not.

I'm sure I could play around with what you sent me and work it out, hopefully.

Thank you for your time.

[Fluff13]

Oops, misread your op. It should be

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Teuchter029]

Just the job.

Very much appreciated Fluffy13.

[Fluff13]

You're welcome & thanks for the feedback