When you’re parsing through large amounts of data in a Google Sheets spreadsheet, conditional formatting can help you find those bits of information that you want. Conditional formatting helps ...

In general, formulas in Google Sheets will contextually update themselves when you copy from one cell and paste to another. But that doesn't happen with formulas used in conditional formatting.

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, ...

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.

At the time of writing (July 2025), conditional notifications in Google Sheets are only available to people using Business, Enterprise, or Education Google Workspace accounts.

The Sheets web app already has these new features, which include most notably the ability to add gradients that are conditional upon the value of the individual cell.

If you want to show negative numbers in red color in Google Sheets, then you can do this using conditional formatting and custom formatting.