Excel Conditional Formatting helps you explore and analyze data visually, detect critical issues and identify patterns and trends.
A conditional format changes the appearance of a cell range based on a condition or criteria. You can use Highlight Cells Rules, Top or Bottom Rules, Data Bars, Color Scales or Icon Sets to visualize data easily, highlight interesting cells or ranges of cells and emphasize unusual values.Excel enables you to create various types of conditional formats: data bars, color scales and icon sets. Data bars are visually powerful because they display a band of color across the cell depending on the value of the cell in relation to other cells in the range you select.
The length of the Data Bar represents the value in the cell. The higher the value the longer the Data Bar.
- Select the range of cells that you wish to apply Conditional Formatting.
- Select Conditional Formatting on the Home tab.
- Point to Data Bars
- Select the desired option – for example, click Blue Data Bar
Learn about Conditional Formatting in the Excel Charting/Data Presentation class at Full Circle Computing!
