Turn positive values to negative values if condition is true
Hi,
Can somebody help with a macro doing the following:
If cell in column A = "Test"
Then turn positive values to negative values in column B+C in corresponding
row
If cell in column A <"Test" then do nothing
If cell in column B or/and cell in column C already has a negative value
then do nothing
Best regards,
Kaj Pedersen
|