Academy ↓
Generate Conditional Formatting in Google Sheets
Creates a custom formula for any use case you can imagine.
Enter your need, describe the range, and it will generate the custom formula in Conditional Formatting.
Conditional Formatting Examples
Write formulas in Google Sheets easily
REGEX
I want to match all rows which contain the word "url" in column A. The word can be anywhere in the cell.
Complex Condition
I want to highlight cells in column A where the value is greater than the average but less than the standard deviation.
Data Validation
I have a column, column A, for ages, and I want to ensure that the entered ages are within a certain range. Between 10 years and 20 years.
Comparision
I want to highlight cells where the value in column A is greater than the value in column B.