I need colors in a bar chart to change automatically when
a certain number (i.e., days) is acchieved. For examples
if a project has less than 100 days the bar line in the
chart is green. Once, the project goes over 100 days the
same bar turns red. Can I do this in Excel?