Conditional formatting improvements in Google Sheets

People using Google Sheets will now have more powerful conditional formatting options. This launch will add the following features:

• 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

Conditional formatting can be added by highlighting the relevant cells and selecting Format > Conditional formatting from the menus.

Release track:
Rapid release and Scheduled release

For more information:
Help Center

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Get these product update alerts by email
Subscribe to the RSS feed of these updates