textbox font colour

[Pilot]

I have a userform which has a number of textboxes. They are titled "Start
Date" and "Expiry Date".
How do I get the expiry date to change colour when 30 days before expiry
date the font changes to orange and when past the expiry date it changes to
red.
Is there a vb code to do that and if so where do I place it?

 

[houghi]

I have a userform which has a number of textboxes. They are titled "Start
Date" and "Expiry Date".
How do I get the expiry date to change colour when 30 days before expiry
date the font changes to orange and when past the expiry date it changes to
red.
Is there a vb code to do that and if so where do I place it?

Conditional formatting is what I use. I would add a field that would
give me the number of days and then ket the conditional formatting
depend on these.

I actualy have an additional field where it not only changes colour, but
also tells me the status. This gives me the ability to use autofilter to
filter on it.

houghi

 

[Pilot]

If I conditional format the cells will the textbox 9which are linked to
cells) also change colour? or do I need to add a code so that the values in
the textbox will change colour?