Conditional Formatting in a Pivot using a formula

[Gesyca_is_joy]

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?

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

 

[GraH]

You can write a formula (VLOOKUP, INDEX/MATCH, XLOOKUP) inside CF and where the found value for the invoice number is the "late fee flag", it turns bold/dark red.