I have a timesheet log with columns
DATE | HOURS | DESCRIPTION OF WORK | PROJECT
An employee may enter several rows for the same date to log the different amount of time with respect to the 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 hours? 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 one same day
is less than 8 (3 + 1 + 2)?