Google has updated the web version of Sheets with improvements made to the conditional formatting settings. Users can now use custom colors and shades to display lower or greater value more efficiently. The update also brings features like strike through and the ability to import or export color scale conditional formatting.
Here is a list containing all the changes as mentioned by Google:
- 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
Source: Google Apps Updates
Come comment on this article: Google brings Conditional Formatting improvements to Sheets