Gesyca_is_joy
Board Regular
- Joined
- Apr 24, 2014
- Messages
- 90
- Office Version
- 365
- Platform
- Windows
I have a pivot table which shows me what invoices are due, and their amount, grouped by week. in the source data I mark if the invoice has a late fee if paid late. this field is not in the Pivot. I'd like to have some conditional formatting wherein the invoice amount is made Bold and dark Red if it has a late fee. but I'm unsure how to write that for the pivot table. below is an example of how my pivot table looks. In this example I would want Example Company 2's invoice amount 627.50 to show dark red because it has a late fee if not paid on time. the "Late Fee" field is part of the source data but isn't in the pivot itself because that makes it way to cumbersome to read when scaled to the amount of information in the real thing.
Is this possible?
Is this possible?
Sum of INVOICE | DUE DATE | ||
Vendor Name | Invoice | 1/18/2020-1/24/2020 | 1/25/2020-1/31/2020 |
Example Company 1 | |||
12345 | 725.00 | ||
12346 | 500.00 | ||
Example Company 2 | |||
55577 | 627.50 |