Google Drive Google Script Google sheets How to ?

Store Passwords in Google Spreadsheet in Encrypted Format

It’s very difficult to remember many things which we need on daily basis like passwords, FTP credentials or any other secret data etc. Also it is very dangerous to save passwords directly somewhere. We sometimes store our credentials in Google Spreadsheet. But is it really secure ? You never know when somebody peep into your …

Continue Reading
Google sheets How to ? Tips

How to Set Conditional Formatting Icons in Google Spreadsheet

We say, one image worth 1000 words. Similarly visual representations are sometimes more meaningful than raw data. Conditional formatting is a life saving feature we find in spreadsheets. It allows to format cells based on some condition. In MS Excel, conditional formatting allows background colors, data bars, color scales and icon sets. Among all, icon …

Continue Reading