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:

mvermaak_1-1677000564901.png

 

then original table:

mvermaak_2-1677000622449.png

 

 

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