Hello All
I have been struggling with a solution to make a calculation based on a conditional formatting result
Let me explain
I have a currency row for which I have made conditional formatting so that a cell fills red whenever there is USD, SEK or NOK text in that cell. - this is working perfectly.
What I would like to do in VBA, is whenever I have a red cell, it will use the value in the cell to the left and multiply it with a cell a few columns to the right (all in the same row)
Then paste the result in the cell to the left from the initial red cell.
So if my active cell is O7 and it's red due to the cell contains "USD" then multiply the value from N7 to U7 and place the result in N7
I hope it makes a bit of sense and you guys are willing to help out
Tnx in advance
I have been struggling with a solution to make a calculation based on a conditional formatting result
Let me explain
I have a currency row for which I have made conditional formatting so that a cell fills red whenever there is USD, SEK or NOK text in that cell. - this is working perfectly.
What I would like to do in VBA, is whenever I have a red cell, it will use the value in the cell to the left and multiply it with a cell a few columns to the right (all in the same row)
Then paste the result in the cell to the left from the initial red cell.
So if my active cell is O7 and it's red due to the cell contains "USD" then multiply the value from N7 to U7 and place the result in N7
I hope it makes a bit of sense and you guys are willing to help out
Tnx in advance