Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Pivot Table Conditional Formatting based on original table data

Copper Contributor

I'm trying to apply conditional formatting for dates in a pivot table, based on information from the original table. is this possible.


more details below:

Pivot table:



then original table:




I want the date on the pivot table to be formatted based on the original table's "Status" column. I've tried conditional formatting with a formula, using vlookup, but not having any luck. happy for any other suggestions.


Many thanks


0 Replies