Conditional Formatting in a Pivot using a formula

Gesyca_is_joy

Board Regular
Joined
Apr 24, 2014
Messages
79
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 INVOICEDUE DATE
Vendor NameInvoice1/18/2020-1/24/20201/25/2020-1/31/2020
Example Company 1
12345725.00
12346500.00
Example Company 2
55577627.50
 

Some videos you may like

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
Joined
Mar 22, 2020
Messages
707
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top