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 = "red"
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
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 = "red"
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