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.
