Two Part Question

[tlindeman]

Could you please supply me with the Code for a chart. I would like a column to change color based on a date. So if today()<July 2011, I would like the color of the column to be orange, else blue.

Thank You
Tony

 

[texasalynn]

sounds like you want a conditional format, use this as formula and select the format pattern color you want

=a1=today()

 

[tlindeman]

Thank you, however, I need the VBA, as far as I am aware, you can not change a column of a chart using conditional formating.

Thank You
Tony