To apply color schemes 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. In the dialogue box 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.