Colouring rows/fields in a form based on a condition!

[User25]

In a form (Form1) a user enters a date and in a subform (Query1 subform) which is based on a query i see the records from a table filtered by that date. In the subform I would like to write a function to sum the numbers of days worked by an employee and if the result is above ten I would like the lines containing the employee to turn red or maybe the Days fields for that employee. Any advice will be appreciated.

[Welshgasman]

Use Conditional Formatting with either an expression or a hidden control that sums the number of days for employee in the

[June7]

Textbox in subform Detail section with expression: =DSum("Days","Attendance","DateWork=#" & [DateWork] & "# AND Employee='" & [Employee] & "'")

Select all textboxes (works for comboboxes as well) on subform and set CF rule:

Expression is: [tbxSumDays] > 10

Should have an Employees table and save EmployeeID into Attendance, not employee name.