Format cells in column H based on text content in column C

[Declamatory]

Good Day Everyone,

Is someone able to show me how to format cells in column H based on the text content in column C.

If part of the text in column C5 contains the text “GBP” then the format of H5 should be "$#,##0.00_);[Red]($#,##0.00)" (GBP currency format)

If part of the text in column C5 contains the text “USD” then the format of H5 should be "[$$-409]#,##0.00" (USD currency format)

The same rule should apply for all cells in column H. There will be some blank rows in the data. It doesn't matter how these cells are formatted as there is nothing in them.

I have tried using conditional formatting and this works fine when recording the macro but errors when running the macro. Is there another routine using VBA that would work.

Thanks

Dec

 

[Declamatory]

That's it Rob!!! You are an absolute legend. Thanks so much. I really appreciate it. Brilliant!

 

[Declamatory]

Hi Rob, The code worked when the 500 rows was specified but the adjusted code doesn't work I'm, afraid. It has ignored some cells in column H and has made some cells that should be in USD format into GBP format and vice versa.