Background color for fields in a subform

[eric.opperman1@gmail.com]

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.

[pbaldy]

The simplest solution is to use Conditional Formatting. That assumes you have no more than 3 conditions in addition to the default.

[eric.opperman1@gmail.com]

Thx! It looks good. I use it all the time in excel, I didn't even think of using it in access

[pbaldy]

Happy to help!