# Conditional Formatting in a Pivot using a formula

#### Gesyca_is_joy

##### Board Regular
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

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### GraH

##### Well-known Member
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.

Replies
2
Views
512
Replies
1
Views
96
Replies
10
Views
236
Replies
5
Views
154
Replies
10
Views
201

1,127,991
Messages
5,628,007
Members
416,286
Latest member
ko15

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back