Try the technique described here:

http://peltiertech.com/conditional-f...-excel-charts/