Skip to Content
0
Former Member
Mar 11, 2015 at 05:34 PM

Conditional format in Crosstab based on Grand Total

83 Views

I have a crosstab showing the grand total (average) for the rows, at the right end of each row.

How can I create a format field formula to compare the cell value (average) in that row to the grand total, and if it that cell is "greater" than the grand total, highlight that cell in yellow?

Thanks for any help.