VBA to Format Date and color it on text string

Hi guys,

I am new on this. What I am trying to accomplish is to have the following text with the date formatted as MMM D, YYYY and at the same time colored it in red.

Like this: Great job with your homework. You have scored 80%. Your next assignment is on March 31, 2015.

Assuming that A1 = 80% and A2 = 03/31/2016

Here is the code I am using:

Please Login or Register  to view this content.

Thank you for your help!

Maybe :

Please Login or Register  to view this content.

or possible

Please Login or Register  to view this content.

This is awesome! Thank you both!

You are welcome, glad to help.


Regards