Conditional colors?

Sep 9, 2011 at 3:50 PM

Is there a way to use conditionally formatted colors for the columns, bars, or lines? Or, can the colors be pulled from a column in the source list? My project needs the ability to show good numbers as green, mid-range numbers as yellow, an bad numbers as red. I would like it to happen automatically rather than have to manually change the colors every time the data values change.