See Below.

[Zac]

In "J" Col I have Etended Sales Figures.
Some may be -Negative.

In "O" Col I have Inventory values which were extracted from our MRP program.
If any of the figures in J are negative, I need to change the inventory value on the same line to a negative.

IS there a way to do it without adding another column, etc. I'm going to try and do it in Conditional Formatting but I don't think that will work..

Thanks,
Zac

[Mark W.]

On 2002-04-22 08:52, Zac wrote:
In "J" Col I have Etended Sales Figures.
Some may be -Negative.

In "O" Col I have Inventory values which were extracted from our MRP program.
If any of the figures in J are negative, I need to change the inventory value on the same line to a negative.

IS there a way to do it without adding another column, etc. I'm going to try and do it in Conditional Formatting but I don't think that will work..

Thanks,
Zac

Formatting does not change the internal representation of a value.

[Zac]

I can Use conditional formatting, selecting "formula" and entering something like: =If(K2<0,M2*-1,).
I can get the number to to change to red, but not negative for some reason.