Conditional Formatting based on other column

by Kula   Last Updated September 11, 2018 13:03 PM

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)?

Tags : google-sheets


Related Questions




Copying values between google sheets

Updated July 26, 2018 21:03 PM