What is conditional formatting?

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

Apply classic conditional formats

To apply single-color/classic conditional formatting,

1. Click on the Format menu.
   
2. Select the Conditional Formatting option.
   
3. Click on Classic from the drop down.
   
4. From the side pane, select the range of cells you want the conditional formatting to be applied to.
   
5. You can format the cells based on cell value, text, date, cell content or a formula.
   
6. You can specify how you want the cells to be formatted, by customizing the color, font style, font size etc.,  
   

Learn how to highlight the entire row either using formulas or without formulas.

Apply color scales as conditional formats

To apply color scales as conditional formatting, 

1. Click on the Format menu.
   
2. Select the Conditional Formatting option.
   
3. Click on the Color Scales option from the drop down menu.
   
4. From the side pane that appears, select the range of cells to which the conditions are to be applied.
   
5. Specify the colors to be applied to each cell, based on the "Minimum", "Maximum" and the "Midpoint" criterion that you provide. These values are by default automatically calculated if you don't provide them.
   
6. Hit Ok. 
   

Apply icon set based conditional formatting

To apply color schemes as conditional formatting,

1. Click on the Format menu.
   
2. Select the Conditional Formatting option.
   
3. Click Icon Sets from the drop down.
   
4. From the side pane, specify the range of cells to which the Icon Set based formatting is to be applied.
   
5. Choose the Icon Set you seem fit, from the list of sets available.
   
6. Set rules for the cell values and specify the icons to be shown when the criterion is met.
   
7. Hit Ok. 
   

Apply data bars as conditional formats

1. Select the range of cells for which you wish to apply data bars.
   
2. Go to Format > Conditional Formatting > Data Bar.
   
3. Choose any preferred color from either Gradient or Solid.
   
4. To customize the color, go to Data Bar > Customize.
   
5. From the side pane that appears, choose the type of fill under Fills.
   
6. Pick the colors for Positive and Negative values using the drop-downs.
   
7. Once you're done, click Apply.
   

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:
   

1. Direction - Allows you to select the direction of the data bars.

Source - Allows you to edit the cell range for which you wish to apply conditional formats.

Rule type - Allows you to change the type of conditional formatting.