Cell text color change on date condition 1

[dataweaver]

"I would like to have the color of date listed in a column change from black to red when the date listed reaches two weeks before the current date.

I am sure it is an easy one but I haven't used my vb knowledge for a few years now I am using excel97.";

 

[JVFriederick]

Suggest using Format Conditional Formating.

You can use =INT(NOW()) to determine the value of today's date