What is conditional formatting

1. Classic
   
2. Color scales
   
3. Icon sets
   
4. Data bars
   

How to apply classic conditional formats

1. Go to the Home menu and click Conditional Formatting .
   
2. Click Classic from the drop-down.
   
3. Select a type of rule you want to apply. You can format cells based on cell value, text, date, cell content or a formula and more.
   
4. In the Conditional Format dialog, select the range of cells you want to format.
   
5. Format the cells based on cell value, text, date, cell content, or a formula.
   
6. Customize your cells by changing the color, font style, font size etc.
   
7. Click Ok.
   

1. Go to the Home menu and click on Conditional Formatting .
   
2. Click on Color Scales from the drop-down.
   
3. In the Conditional Format dialog, select the range of cells you want to format.
   
4. Click Customize to define your "Minimum", "Midpoint" and "Maximum" values. If not specified, default values will be applied.
   
5. Click Ok.
   

1. Go to the Home menu and click on Conditional Formatting .
   
2. Click on Icon Sets from the drop-down.
   
3. Click Customize to modify and define your own rules.
   
4. In the Conditional Format dialog, select the range of cells you want to format.
   
5. Choose the icon set you'd like to use from the list.
   
6. Select a rule type and define conditions for each icon. You can format cells based on Number, Percent, Percentile or Formula.
   
7. Click Ok.
   

1. Go to the Home menu and click Conditional Formatting .
   
2. Click Data Bars from the drop-down.
   
3. Click Customize to define your own conditional format rules.
   
4. In the Conditional Format dialog, select the range of cells you want to format.
   
5. Choose the type of fill under Fills.
   
6. Pick the colors for Positive and Negative values using the drop-downs.
   
7. Click Ok.
   

1. Minimum and Maximum - Allows you to select the type of value you wish to give for maximum and minimum values.
   
2. Borders - Allows you to pick the border type and also the border color for positive and negative data bars.
   
3. Axis Position - Allows you to select the axis for the data bars. The three types of axis positions include:
   
4. Automatic - The axis position will depend on the length of the positive data bar.
   
5. Midpoint - The axis position will be at the center of the cell.
   
6. None - The axis position will depend on the length of the negative data bar.
   
7. Direction - Allows you to select the direction of the data bars.