peltiertech.com
Conditional Formatting of Excel Charts - Peltier Tech Blog
It's easy to conditionally format an Excel worksheet, but not a chart. VBA can be used, but this article shows how to conditionally format charts without VBA.