I want to do this: status is B7 and B7 equals RED so it give

[Guest]

So let's say that in B7 there is the word RED. I would like to do have in another cell something like (Status is B7). So in fact excel will show: Status is RED.

How can I do that?

Thanks in advance!

 

[gplhl]

On 2002-02-27 10:33, Anonymous wrote:
So let's say that in B7 there is the word RED. I would like to do have in another cell something like (Status is B7). So in fact excel will show: Status is RED.

How can I do that?

Thanks in advance!

="Status is "&B7

 

[Guest]

It works!

Thanks a lot!