At the recent Academy I asked about building a row format formula so that amounts with a variance of say > 15% would be highlighted, except for if the variance amount were less than a specified amount (e.g. I don't want to flag a 30% variance if the variance is $50). It was suggested that I post my question here. So, can someone help me with this formula?
Thanks.

Hi EMB,

In general, the condition for applying the row format would require an 'AND' statement so that multiple conditions are checked for, such as:

IF( AND( {Variance} >0.15, {Variance Amount} > 50.00 ) , "HighlightYellow" , " " )

In order to get a useful formula that meets all of your desired conditions, you need to clarify which records with a variance over 15% you want to ignore. Maybe it is as simple as this, or perhaps there are various levels and combinations of variance thresholds that you want formatted, in which case the formula becomes more complicated.

EMB:

Supports solution only captures positive variances. Are you not also looking for occurrences of negative variances? To make this work you want to use an Absolute command on your variance amount:

IF( AND( ABS({Variance}) >0.15, ABS({Variance Amount}) > 50.00 ) , "HighlightYellow" , " " )