Tag: Conditional Formatting

How to Highlight Cells Containing Special Characters in Google Sheets

How to Highlight Cells Containing Special Characters in Google Sheets

With the help of a single piece of formula, you can highlight any cell, column, row or even an array that contain any special characters in Google Doc Spreadsheets. Special characters here means any...
Highlight Cells Based on Expiry Date in Google Sheets

How to Highlight Cells Based on Expiry Date in Google Sheets

In a spreadsheet, a highlighted cell can provide you enough information about the content of that cell. It can alert you about an important date, a milestone or something similar. Before going to explain...
Indirect Function in Conditional Formatting in Google Sheets

Role of Indirect Function in Conditional Formatting in Google Sheets

Do you know the role of Indirect function in Conditional Formatting in Google Sheets? If not follow this tutorial. Here you can find a very useful conditional formatting example and also learn to use...
Highlight Cells based on multiple Conditions in Google Sheets

How to Highlight Cells based on multiple Conditions in Google Sheets

I know the title is bit confusing for you. So let me first explain what I meant by saying Highlight Cells based on multiple Conditions in Google Sheets. Here I meant to say two...
How to Highlight Only Texts in Google Sheets

How to Highlight Only Texts in a Column or Row in Google Sheets

Let's see How to Highlight Only Texts in Google Sheets. I am beginning few Google Sheets tutorials related to conditional formatting. Conditional formatting can play a vital role in data cleaning and with this tutorial,...

Google Sheets Formulas

In Google Sheets How to Total on Each Changes in a...

As of now, there is no option in Google Sheets similar to Excel's Group or Subtotal command. This command enables users to add total...

Inspiration

Best Sheryl Sandberg Quotes from Virginia Tech Commencement Speech

The aura of Steve Jobs' Stanford University Commencement Speech, which he made more than a decade ago still continues. After watching his commencement speech...