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

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 selected cells now show Data Bars, along with the original numbers. In this example, the Green

Using Greenbar formatting in Excel has a nice retro look. It is also still easier to follow the lines across the page. This article will discuss three options for applying greenbar formatting to a report. Method 1 Use AutoFormat AutoFormat Settings Window