Hello,
I am attempting to create a pivot table that would have Conditional formatting. I can add conditional formatting to the table as a whole, but I need separate rules for each column and excel just isn't doing it. I have done all the research I could think of to figure this out on my own, but this seems like a odd limitation for Excel. So basically the question is this, can seperate rules be applied to each column of a pivot table rather than the pivot table as a whole?
(Example: One column of the Pivot Table shows the number of times an individual has had an all day occurrence and the rule would be >5 format Red Fill, the other column would be the number of times an individual has a partial day occurrence and the rule would be >6 format Red Fill) (There are multiple rules but they all follow that same standard.)
Any help, even if it's "It can't be done in a Pivot Table" would be appreciated. Thank you!
I am attempting to create a pivot table that would have Conditional formatting. I can add conditional formatting to the table as a whole, but I need separate rules for each column and excel just isn't doing it. I have done all the research I could think of to figure this out on my own, but this seems like a odd limitation for Excel. So basically the question is this, can seperate rules be applied to each column of a pivot table rather than the pivot table as a whole?
(Example: One column of the Pivot Table shows the number of times an individual has had an all day occurrence and the rule would be >5 format Red Fill, the other column would be the number of times an individual has a partial day occurrence and the rule would be >6 format Red Fill) (There are multiple rules but they all follow that same standard.)
Any help, even if it's "It can't be done in a Pivot Table" would be appreciated. Thank you!
