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:

[separator type=’transparent’ color=” thickness=” up=’5′ down=’5′]
  • 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
[separator type=’transparent’ color=” thickness=” up=’5′ down=’5′]

[separator type=’transparent’ color=” thickness=” up=’5′ down=’5′]

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

3 thoughts on “Conditional formatting improvements in Google Sheets

  1. Umut Alpaslan says:

    Everything is very open with a clear clarification of the challenges. It was really informative. Your website is extremely helpful. Thanks for sharing!

Comments are closed.