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
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