Conditional formatting improvements in Google Sheets

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 ... 14.58

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