Changing font Color linked to Date Key through macro

I am looking to change the color of my text through a macro, which is fine. But I want to change the color according to a date key. So every time I update my date once a week, a new series is "blacked in". The series has the link already in it, I just need it to change color (to black) every time I update it.

I hope this makes sense, does anyone have a sample I could try out for this?

Thank you

Can you post the example in question?

This will change a particular range's font color to black:

Please Login or Register  to view this content.

If you have a cell that houses the date that you wish to use as the validation date value:

Please Login or Register  to view this content.

Does this help?