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" , " " )