In the Conditional Formatting menu, data bars are a main category. There are six presets for data bars with gradient fills, and six presets for data bars with solid fills. Except for the fill, these data bar presets are the same. Excel builds a live previ

On the Ribbon, click the Home tab, and then in the Styles group, click Conditional Formatting. In the list of conditional formatting options, click Data Bars, and then click one of the Data Bar options -- Gradient Fill or Solid Fill. (see tips below) The

Progress Bars in Excel 2010 “Bar-type” conditional formatting has been around since Excel 2007. But Excel 2007 would only make bars with a gradient – the bar would get paler and paler towards the end, so even at 100% it wouldn’t really look like 1