I have a subform that contains a list of outstanding tasks. The subform is based on a query. Each record in the subform has an "Age" field.
I would like to change the background color of the Age field in each row based on the content of the cell i.e. if the value in Age for the first row < 5 then background color = green. If the value is between 5 and 10, then background color = orange, etc.
Any help will be appreciated.