Skip to Content
Former Member
Mar 28, 2006 at 12:36 PM

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?


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.