Is there any way to do conditional formatting on a chart?  As an example: If a column reaches a specific value change the color.

It can be done in a table.  It would be nice to be able to do this in a chart as well.

Thanks.

One other question.  In a table can conditional formatting be based on the value of another column?