Formula with If and others
 

=if((B1-A1)/A11.1,"UP",if((B1-A1)/A1<.9,"DOWN","???"))

You can then put a conditional format on the cell to change the color with
FORMAT - CONDITIONAL FORMAT
Enter Cell Value is Equal to "UP" and "DOWN" and format as desired.

"Eli" wrote:

For example, I have three columns as follows:

A B C
1 100 120
2 100 80

I'd like to set up a formula applying to the cells in column C. If B1 value
is higher than A1 by 10%, C1 will show a word "Up" in green. With this
formula C2 will have "Down" in red. Appreciate your help.
Thanks,
Eli

Formula with If and others
 

I'm having a brain fade tonight on formulas. I guess it's the foot that was
hit with a softball and it's already got quite the bump.

In the if, change the expression to

=IF(B1/A11.1,"UP",IF(B1/A1<0.9,"DOWN","???"))

"Eli" wrote:

For example, I have three columns as follows:

A B C
1 100 120
2 100 80

I'd like to set up a formula applying to the cells in column C. If B1 value
is higher than A1 by 10%, C1 will show a word "Up" in green. With this
formula C2 will have "Down" in red. Appreciate your help.
Thanks,
Eli

Formula with If and others
 

For example, I have three columns as follows:

A B C
1 100 120
2 100 80

I'd like to set up a formula applying to the cells in column C. If B1 value
is higher than A1 by 10%, C1 will show a word "Up" in green. With this
formula C2 will have "Down" in red. Appreciate your help.
Thanks,
Eli

Formula with If and others
 

Hi Barb,
It works. Really appreciate it.
Have a good night!
Eli

"Barb Reinhardt" wrote in message
...
I'm having a brain fade tonight on formulas. I guess it's the foot that
was
hit with a softball and it's already got quite the bump.

In the if, change the expression to

=IF(B1/A11.1,"UP",IF(B1/A1<0.9,"DOWN","???"))

"Eli" wrote:

For example, I have three columns as follows:

A B C
1 100 120
2 100 80

I'd like to set up a formula applying to the cells in column C. If B1
value
is higher than A1 by 10%, C1 will show a word "Up" in green. With this
formula C2 will have "Down" in red. Appreciate your help.
Thanks,
Eli