diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


Google adds Conditional Formatting to Spreadsheets

If you select one or more cells in Google Spreadsheets, you’ll see a new option in the context menu: “Change format with rules“. You can change the color of the text or the background of a cell if that cell verifies one or more rules. Google Spreadsheets lets you format the cells that contain a specific text, a date or have a value in a certain range.

Other spreadsheet apps, like Microsoft Excel 2007, have more advanced options like showing gradient colors for the values, highlighting the top x% values, finding duplicate values or defining a rule based on a custom formula.

The second new feature lets you hide rows and columns that shouldn’t be displayed all the time. Select the column or the row, right-click and choose “Hide column (row)”. To make it visible again, click on the small rectangle that replaces the column or the row.

Google Spreadsheets seems to evolve much faster that Google’s word processor and there aren’t too many important missing features. What would you like to see in the next iterations of the product?

Google, Spreadsheets, Google Docs, New Features

Source:? googlesystem

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...