Highlight average price

[easternfish]

Hi,

I need to be able to highlight the highest and the smallest price or have some kind of color pattern from light red to dark red.

so for week 1 of Jan 2011 $5.50 I need it to be red and 2010 $8.65 to be green or from light red to dark red.

I have try using the Visual Cues and expressions but I'm not able to make this work.

please let me know if have an idea of what to do.

thank you so much!!!

[Gysbert_Wassenaar]

See attached example. Click on the + in front of the expression on the Expressions tab and then select Background Color to see the expression for the background color.

[easternfish]

Genius!

Thank you