Text Colour

[PRodgers]

I have a macro that using a formula to calculate the financial quarter from a date column. I want the values that the macro displays to be displayed in colour (red) and font weight set to bold. Can anyone help with this, my vba macro is as follows:

Please Login or Register  to view this content.

[StephenR]

Like so?

Please Login or Register  to view this content.

[PRodgers]

Like so?

Please Login or Register  to view this content.

Thanks Stephen, that works well, really appreciate your help