Calculation based on conditional formatting

[dutchmhk]

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

 

[dutchmhk]

A new thread opened earlier today:

VBA Compare column data from two wordbooks and show results

Hi all First of all - I've had excellent help from you guys in here, a few days ago with another VBA issue that I had. It was solved with a few lines of code within hours of posting the thread - AMAZING! Thank you so much! So here goes for my second issue: I've been trying to compare data from...

www.mrexcel.com

​