Changing the text colour property

[toon10]

Hi

I'm a total novice with excel but can program with VBA. My problem is that I have a date in a cell and I want to turn the text colour red if that date is the same date as today or if it is over todays date. (Something like: If C1 =< now() Then C1.Textcolor = &quot;red&quot

Could someone tell me what the correct syntax is and how I use it (ie. Put in in a cell formula, a macro, or some sort of code window!)

Thanks
Nora

 

[jebry]

Hi Nora!

The easiest way to do it is to select the cell and click on Format on the menu bar and choose conditional formatting.

hth Jeff Bridgham
bridgham@purdue.edu