conditional formating

[minimus]

Here is what I want it to happen:

There is a number in cell A1 and a text in A2. When I change the number in
A1 I want the "text" change in A2.
How can I do this with conditional formatting? I know how to change the
"format" of A2, but what I want is a change of the text in A2.

 

[ramz]

um... why not just use an "IF" statement in A2...?

 

[Bob I]

Unless it is the COLOR of the text that changes, you can't use
conditional formatting. You would have to use an IF statement instead.

 

[minimus]

um... why not just use an "IF" statement in A2...?

How can I do this with the IF statement in A2?

I mean

if A1=1 then A2="number is one"
if A1=0 then A2="number is zero"

Can I do such a thing?

 

[ramz]

IF ( <condition is true>,<condition is false>)

you can nest if statements if there are more than 2 possible
conditions of the data in A1. You just have to think logically.

 

[Gord Dibben]

If 1 or 0 are your only possible inputs for A1

Entered in A2

=IF(A1=1,"number is one","number is zero")


Gord Dibben MS Excel MVP

 

[minimus]

Here is what I want it to happen:

There is a number in cell A1 and a text in A2. When I change the number in
A1 I want the "text" change in A2.
How can I do this with conditional formatting? I know how to change the
"format" of A2, but what I want is a change of the text in A2.

Thanks all!!!

I did it. I used "if" to change text, and "conditional formatting" to change
the format of the cell.