CHANGING THE APPEARANCE OF ONE CELL BASED ON THE CONTENT OF ANOTHER

[HighlandPiper]

Hi all
I am working on a spreadsheet with formulae. I am trying to hide a date in one cell when N/A is displayed in another. The cell I am trying to hide already has a formula in it and I suppose I need to had some form of nested IF statement. I have no idea how to do this.

The fomula in the cell below 'Practical Period Start Date' is: =IF('#FORMAT SHEET'!Z4="","",'#FORMAT SHEET'!Z4). I need to keep this formula, but is there anyway I can add to the existing formula to hide the content of this cell, or change it to 'N/A' when the 'Aim Type 5' is 'N/A'. Once I have a solution I will need to replicate the formula to a number of other cells, which I will be able to manage.

Any help would be appreciated.

Highlander

 

[Joe4]

OK, you haven't told us what cells those values you posted are in, so you will need to fill in those details.
But the formula should be structured something like this:

=IF(OR('#FORMAT SHEET'!Z4="",cell="N/A"),"",'#FORMAT SHEET'!Z4)

You will just need to change "cell" to the address of the cell of the column that "Aim Type 5" is in.

 

[HighlandPiper]

OK, you haven't told us what cells those values you posted are in, so you will need to fill in those details.
But the formula should be structured something like this:

=IF(OR('#FORMAT SHEET'!Z4="",cell="N/A"),"",'#FORMAT SHEET'!Z4)

You will just need to change "cell" to the address of the cell of the column that "Aim Type 5" is in.

Hi Joe

That is excellent, thank you very much. Perfect!
I have added the cell reference B24. I also stuck N/A between the "" so that it returns a value of N/A instead of having a blank box.

=IF(OR('#FORMAT SHEET'!Z4="",B24="N/A"),"N/A",'#FORMAT SHEET'!Z4)

Thanks again really appreciate it.

Highlander

 

[Joe4]

That is excellent, thank you very much. Perfect!

You are welcome!

I have added the cell reference B24. I also stuck N/A between the "" so that it returns a value of N/A instead of having a blank box.

That is fine. I was just going by what you had your original formula doing, which was returning nothing (and you had said either hide it or return "N/A").
Just note that the way you wrote it will also return "N/A" when Z4 on the FORMAT SHEET is blank.