Conditional Formatting a Sub Summary
I'm wondering if it's possible to add conditional formatting to a sub summary based on what the sub summary is on.
For instance, i have a report listed sorted by items and the qty of items that i have.
I have a sub summary that includes a summary field to add the total qty of each item.
I'd like to add conditional formatting to the summary field based on each item.
ie...if type A item is lower than 50, turn red.
if type B item is lower than 45, turn red.
if type C ite is lower than 125, turn red.
Is there any way to do this?
Thanks for the help!