Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Conditional Formatting on Column Sub-Total — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Conditional Formatting on Column Sub-Total

edited Feb 23, 2017 3:37PM in General Transactional Reporting (OTBI) 1 comment



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. 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!