Hi I have been looking through posts to find the answer but I am getting more confused. Hopefully some kind person can show me the code...

I have 3 columns of numeric data in my spreadsheet that has been populated by a 3rd party import application (I cant access the spreadsheet until after it is populated from this application which removes all conditional formatting but does keep any VBA code etc). The 3 columns are fixed position but there are hundreds of rows (possibly a different number of rows each time the import is run)

I need to see if Column 1 + Column 2 <> Column 3. If so then I need column 3 to be highlighted (lets say in red background).

I would be very grateful if someone could provide me with the code to apply the formatting. I would launch it from a command button.

Thank you so much.

Tony