Bar Chart Formatting

[pgevaux]

I want to know how to conditionally format a bar chart so that the colour of the bars correspond to the value. For example, I want the top three values to be gold, silver, and bronze (or colours similar). I don't want this formatting to be static. Each week the top three could change.

Another example would be to have all bars over a certain value to be red. Any ideas?

Thanks

Phil