Hi All,
I need your help to create conditional formatting in pivot table when it meets below condition.
1) Highlight in green color when the Oppurtunity Section in col B and Parent sector in columns F till AH match.
2) It should highlight color when the data in column are expanded.
Attached is the example I tried. But the conditional formatting doesn't work when the rows are expanded.
Please see attached and help to find solution.
Regards,
Vijay
Bookmarks