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

Data bar can be accessed from the Home menu ribbon’s Conditional formatting option’ drop-down list. If we go there, we will be able to see Gradient Fill and Sold Fill Data bar. Whereas gradient fill uses the shades in the cell with values and solid fi

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