Conditional Formatting in Google Sheets

Google Sheets now has more powerful conditional formatting options.

• Ability to add gradient conditional formatting rules (e.g. green -> orange, where the lowest numbers are shaded green and the highest are shaded orange, with gradient shades in between
• More style choices like bolding, striking through, and italicizing text based on conditional formatting rules
• A new look for the conditional formatting editing pane
• Import/export of color scale conditional formatting

To use the conditional formatting tools:

1. Click on "format"
2. In the drop down menu, click on "conditional formatting"
3. Choose your formatting options in the pane that appears on the right.