Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with 3 columns: Expression A (2010Sales), Expression B(2011Sales), and Expression C(YoY%). I want to conditionally format the column for Expression C...but only where the value of Expression B is > 10,000. I can't figure out how to accomplish this. Is it possible?
Thanks, Dan
Sure, change the background color in the 3rd expression to something like if(column(2)>10000, red(), green())
Thanks, Daniel. That worked, except I probably should've mentioned that I want to conditionally format Expression C as you've described, but only when the value in Expression C is +/- 10%. In other words, highlight the value in Expression C when it is +/- 10% AND the value of Expression B is > 10,000. Any suggestions?
Thanks again.