View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] koperstexdq_dont_use@gmail.com is offline
external usenet poster
 
Posts: 28
Default 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