I am wondering if there is a way to have conditional formatting for E10.
E10 is the total hours:minutes an employee is sick; formula is =SUM(E11:E9999). The format for column E is [h]:mm.
N4 is the percentage of the employee's position allocation, where 100% is equivalent to full time (formatted as a percent with no decimal places). N5 has a formula: =N4*64. 64 is the threshold for full-time employees (64 hours in 12 months). So N5 will calculate the sick hours' threshold for employees working less than full time.
I would like conditional formatting for E10 when the total of E10 is greater than N5. I do not know how to write the conditional formatting formula. Any help is greatly appreciated!
E10 is the total hours:minutes an employee is sick; formula is =SUM(E11:E9999). The format for column E is [h]:mm.
N4 is the percentage of the employee's position allocation, where 100% is equivalent to full time (formatted as a percent with no decimal places). N5 has a formula: =N4*64. 64 is the threshold for full-time employees (64 hours in 12 months). So N5 will calculate the sick hours' threshold for employees working less than full time.
I would like conditional formatting for E10 when the total of E10 is greater than N5. I do not know how to write the conditional formatting formula. Any help is greatly appreciated!