I have a time sheet log with columns DATE, HOURS, DESCRIPTION OF WORK, PROJECT. An employee may enter several rows for the same date to log different amount of time with respect to specific project.
How can I use Conditional Formatting to display red color or warning if the sum of hours for one date is less than 8? For example three rows:
| 11.08.2018 | 3 | Work descr1 | Project 1 |
| 11.08.2018 | 1 | Work descr2 | Project 2 |
| 11.08.2018 | 2 | Work descr3 | Project 3 |
How to highlight the cells with hours since the sum of hours for 1 same day is less than 8 (3 + 1 + 2)?