You cannot use Conditional Formatting per se. But Jon tell how to do it at
http://peltiertech.com/Excel/Charts/...nalChart1.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"MJJONES618" wrote in message
...
How do you use conditonal formatting to change a bar color on a bar chart?