Change font color based on the ending text string (date) of a cell

Hello!

I have a range from Cells B2:E5. Within each cell, there is a text string with a bullet point. At the end of each text string, there is a date in the format (mm/dd) and the text string also includes these parenthesis. The text string will also sometimes either include the words "Green*", "Yellow*", or "Red*", AFTER the date or the text string could not contain any of these. However, if the text string does contain one of these words it will ONLY be one of them never two. What I want the macro to do is the following:

- If the string DOES NOT include (Green*, Yellow*, Red*), then I want this text to be GREY.
- If the string CONTAINS any kind of (Green*, Yellow*, Red*) AND the date within the string is today or prior, then I want this text to be RED.
- If the string CONTAINS any kind of (Green*, Yellow*, Red*) AND the date within the string is AFTER today (in the future), then I want this text to be BLACK.


However, there is a catch. Even though the text string can contain the words ("Green*", "Yellow*", or "Red*") I want every single one of these text string to remain their color in nature. Meaning even though the text string qualifies for a certain parameter for the string to be GREY I still want the text string that contains "Green*" to be the color green, and so on for Yellow or Red.

Please see the example workbook attached.