Using Exceptions to highlight values based on Result row

Is there a way to highlight through Exceptions an individual cell by comparing the value in that cell to the Result above?

Example:

Result: 500 (Avg)

Indiv. value :400 (highlight red for less than Result)

Indiv. value :600 (highlight green for more than Result)

I am able to create an Exception that highlights the cell based on a constant value or a value that is entered by the user, but found nothing that dynamically determines if the cell should be green or red.