I am using crystal reports version xi release 2

In my cross tab i have two summary fields like this
1)sum of @TotalTrailerCnt
2)Max of @TotalInvCnt.

I want my cross tab to compare these sums and highlight the first one if it is less than the second. i.e.

if sum of @TotalTrailerCnt < Max of @TotalInvCnt then
highlight sum of @TotalTrailerCnt with yellow color..

any help is greatly appreciated.

we can do that however the issue is how to write the conditon in the formula...

Anyway I have got answer from another post i would liek to share it with you guys if some one has the same problem and if they come across this forum that will help thme..

The solution which i got from another post is as below

You can do this if you reverse the order of the summaries. The highlighted summary must be the second one.

In preview mode, select the first summary->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
numbervar first := currentfieldvalue;
false

Select the second summary->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
numbervar sec := currentfieldvalue;
false

Then with the second summary still selected->format field->border->color->background->x+2 and enter:

whileprintingrecords;
numbervar first;
numbervar sec;
if sec < first then
crYellow else
crNocolor