How to Use Conditional Formatting on a Desktop Browser
Conditional formatting means that when specific conditions are met, the background and text color in designated Google Sheets cells instantly changes. This is useful when you want to see certain information or call out specific data. Here’s how conditional formatting works for Google sheets on a Windows PC or Mac using Chrome, Firefox, Safari for Mac, or IE 11 and Edge for Windows.
How to Use Conditional Formatting on an Android Device
Here’s how conditional formatting works for Google Sheets on an Android device.
How to Use Custom Formulas
Google Sheets provides more than a dozen formatting conditions dealing with text strings, dates, and numeric values. You’re not limited to these default options. Use a custom formula to apply a condition to a cell range based on values from other cells, which isn’t an option with the predefined selections. This example uses a custom formula to show when the same value appears in more than one cell using the COUNTIF function.
How to Remove Conditional Formatting on a Desktop Browser
It’s easy to delete a conditional formatting rule. =COUNTIF(B:B,B2)>1
