CF question

[Mel Smith]

I am trying to format cell AA2 on my spreadsheet so that if any cell in the range I4:IZ = Wrong it should display Fail, otherwise Pass.

Any help will be appreciated.

Mel

 

[Mel Smith]

I forgot to add that the range should be I4:Z4. Also if the range is empty, so too AA2 display nothing.

Thanks.

Mel

 

[awoohaw]

Is Column AA a calculation? If so, what is it? What do you mean by "WRONG"? Does the word "WRONG" show up in I4:Z4?
With what you have stated, the formula in cell AA4 would be:

=IF(Countif(I4:Z4,"Wrong")>0,"Fail","")

But, that is a formula not a format, so unsure if it is close to what you want. Is AA supposed to be a number returned from another calculation?

 

[Mel Smith]

AA2 is an empty cell Cells I4:Z4 will each display either "Correct" or "Wrong"

Mel

 

[Mel Smith]

Sorry, I4:Z4 will be blank, or display "Correct" or "Wrong"

Mel

 

[awoohaw]

I don't think you can format a blank cell as a string. See what I put in POST2, I edited it.

 

[Mel Smith]

Thank you. I'll have a bit of a play with that.

Mel