Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two dimension and 8 expressions in a pivot table.
I am trying to highlight the background color for the expression that has the highest value of all the expressions on each row for that dimension value (TestName). So, for Sunspider, it would be Exp7, I would want a blue background for that best one. I am not sure how to consider the 8 expressions columns on a row in the code as a set.
Anybody have any ideas how to do that?
Jamie, nice, thanks....
Jamie,
How do you select the null entries to fill those?
Instead of doing the checking for missing data within the expression, I just told the Presentation tab of the object to put "Blocked" in the cell as opposed to "-". The problem here is that I'm not sure how to make those red.
Understood… Not quite sure either, must be a little thing I have off. Thanks….
Jamie,
In this case, Visual Clues - Text - Red will work since only text is the missing.
D
Perfect! Cheers