Hi Everyone,

I am trying to format cells as part of a larger macro that does various reporting, pivots etc. Because conditional format painter does not work in vba I am trying to get some coding that will do the following:

Column F has some cells blank and some cells containing text e.g. “Total GBP” or “Net GBP Deals”. Where the cell in column F contains the text “GBP” I would like to format the corresponding cell in column H in GBP currency format. Where column F contains “USD” I would like the corresponding cell in column H in USD currency format.

The number of lines with data will change every time the user runs the macro and there will be some rows that are blank in between data.

I'm pretty new to VBA so any help you can give me would be appreciated.