Highlight Highest/Lowest

Content

Hi,

I am wondering if there is an easy way to change the formatting (color) or a row in a report based on if the value in one of columns is the Highest/Lowest of all the rows of data?

so if you had the following data it might look something like this: making the lowest in red and highest in green

a	10
b	3
c	56
d	23
e	11

Any Help is appreciated!