conditional formating

  • Thread starter Thread starter minimus
  • Start date Start date
M

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.
 
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.
 
ramz said:
um... why not just use an "IF" statement in A2...?
Click to expand...

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?
 
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.
 
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 said:
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.
Click to expand...

Thanks all!!!

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