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

Conditional format in Crosstab based on Grand Total


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.