On my form, there's a text box containing a date, tbDOExp (Date of expiration) bound to table field DOExp. I want to change the background color of the tb depending on how current value tbDOExp compares to the current date. If current date is less than but within 10 days of DOExp I want the background color to be light blue. If the current date exceeds that of tbDOExp I want the background to display in light red.
Here's what I get:
Here's the Conditional Formatting specs:
I tried reversing the order of the conditions but then "both" fields display in light red. There must be something fundamental to CF that I don't understand?