title: Excel Conditional Formatting Data Bars based on Color
body: <p>I cannot find a way to change the color of an Excel data bar based on value. Current formatting options only permit different colors based on positive/negative values. I'm currently using Excel 2010.</p>
  
  <p>I would like to have the color of a data bar show up as 'red' if the value if between 0-0.3, 'yellow' if the value is between 0.3-0.6, and 'green' if the value if between >0.6.</p>
  
  <p>Would really appreciate any info people could share.</p>
  
  <p>Thanks,</p>
  
  <p>TB</p>