How to change the font of a specific formula which is part of an Excel Cell?

="InterContinental Vienna @ "&M9&" "&M42&" p/room p/night"

based on the above example, M9 = EUR and M42 = 150

Result I am looking for is:

InterContinental Vienna @EUR 150p/room p/night

How do I do this using VBA for each row in a specific column where M9 appears in the cell?

Recent Questions...