We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether ...

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...

Apps Script is just one of the many Google Docs features that you're missing out on and worth a try. The cool thing about ...

Extending Conditional Formatting in Google Sheets Using Dynamic Date Calls. By David Nagel; 03/19/14; Google Sheets, the spreadsheet tool that's part of the Google Apps productivity suite, lets ...

If you want to color code answers in Google Sheets, you must use the Conditional Formatting feature. Conditional Formatting makes it easy to identify certain cells or highlight certain values.

While there is no shortage of habit tracker apps, you don’t have to add another app to your phone home screen or the desktop taskbar. Use Google Sheets to get the job done. By setting up a simple ...

Google Sheets doesn’t provide such an option at present; however, it’s still possible to highlight duplicates in it using a custom formula and some conditional formatting rules.

Google Sheets now lets Google Workspace users set conditional notifications, so they’ll receive alerts when certain criteria are met. It looks even easier to use than a similar feature in Excel ...

The problem: Using conventional techniques, conditional formatting allows you to specify a range of cells that will determine the formatting within the same spreadsheet; the data usually cannot be ...

The problem: Using conventional techniques, conditional formatting allows you to specify a range of cells that will determine the formatting within the same spreadsheet; the data usually cannot be ...