1. Have a text box control (txtDueDate) in the detail section of my report with conditional formatting so if the date is between 9/1/2011 and Date()+90, it turns background yellow and fore Red.
2. Have another control named txtDescription in the report detail area.
3. Want the txtDescription row to also turn these colors when it falls between the date range of the txtDueDate
Looked on MS office help site where they claimed Conditional formatting would do this but don't know how to write the expression. Or, should this be done with VBA on Properties or Report Properties i.e. On Load, On Open etc.