Use conditional formatting to help you visually explore and analyze data, detect critical issues, and identify patterns and trends. Conditional formatting makes it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visua

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

The data will be highlighted based on the given conditions and the corresponding formatting. Data Bars. You can use colored Data Bars to see the value in a cell relative to the values in the other cells. The length of the data bar represents the value in