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

Apply the Light Blue Data Bars conditional formatting in the Gradient Fill section to the selling prices. Create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that contain 98% or higher for