Hello EF community,
I am having an issue with conditional formatting of a pivot table. I generated a formula in my original dataset to generate a "FLAG" if certain criteria are met for 3 different scenarios - each with their own column. I included these in my pivot table, columns, W:Y, with the intent to highlight the entire row if any of the 3 columns trigger the "FLAG" input.
I created 3 conditional formatting rules based on the input trigger of "FLAG" in cell AC2, yet the rule appears to only partially work (and select other non "FLAG" inputs simultaneously.
I'm hoping its an easy fix and that I am making a simple mistake.
For reference - though the pivot only reaches to around row ~1300, I set the parameter to row 1800 in the event my dataset becomes larger.
Thanks in advance for your support!
-Cobraman
Bookmarks