Conditional Formatting on a form

[AndyC121]

=[DispatchDue]-Date() & " Days Remaining" show days remaining on my form from a predefined date entered from a calculated combobox (normally19 or 20 process days)

Value > [DispatchDue] turns green when entered on form
Value <=[DispatchDue] turns red when due or -days



How do I get it to turn orange say 10 days before its red?

[ranman256]

If you put the days remain in the query behind the form,
Days: dateDiff("d", DispatchDue],Date)

then your calcs can be off the days field,
days>0 and days<11