Conditional Formatting on Column Sub-Total
I've built a sickness report that counts the number of instances of sickness and number of days sickness over a time period.
I've figured out how to add a sub-total for each employee (i.e. Joe Bloggs has had 3 instances / 12 days sickness) over the time period. However, what I'd like to do is add conditional formatting to the sub-total line for each employee for when they hit our internal sickness flag levels, but I'm struggling to assign this to the sub-total line, as opposed to the raw data itself.
I've attached an image to show what I'd like - the conditional formatting is on the data itself - I'd like it on the sub-total line if possible.