Guides & Tutorials

When you insert a header in Microsoft Word on one page, by default, the header you inserted will apply to all the pages in that document. This makes sense when …

Working with large amounts of data can be overwhelming. Even though the human eye can easily spot discrepancies, identifying minor differences or similarities between data items is still challenging. With …

In this guide, you’ll learn how to create and use any conditional formatting custom formula in Google sheets. The preset conditional formatting rules are very useful and versatile. However, it’s …

Long Microsoft Word documents such as detailed project quotations, student’s project works or thesis, proposals, annual reports, product manuals, technical white papers, and so on require formal features like page …

In Google Sheets, you can easily strikethrough text or cells. There are four options for doing this: a keyboard shortcut, the strikethrough button in the menu bar, the strikethrough function …

Drop-down lists are common in spreadsheets like Google Sheets. It allows you to specify choices that users of your Google Sheets can make without having to type them themselves. It …

Checkboxes will assist you in making your Google Sheets as simple to use as possible. They make taking an action on your spreadsheet as easy as, well, checking a box. …

Example 1: Highlighting Cells with High or Low Values

It is strongly advised to use Google Sheets conditional formatting based on the value or text of another cell. If you want to fully utilize conditional formatting, you should do …

Conditional formatting makes it easy to highlight cells in Google Sheets. It’s a little more difficult, however, to highlight an entire row in a data set that has multiple columns. …