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

Match Text

I want to match all rows which contain the word "url" in column A. The word can be anywhere in the cell.

Complex Condition

Greater Than and Less Than

I want to highlight cells in column A where the value is greater than the average but less than the standard deviation.

Data Validation

Within Range

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

Compare Columns

I want to highlight cells where the value in column A is greater than the value in column B.

Google Sheets Tools

Google Sheets Tools to make your spreadsheet life better. Create Faster. Style Better. Sell More. Automate Your Business.

Formula Generator Free For Members

Break through any frustrating Google Sheets formula. Try for free.

Sparkline Generator Free For Members

Creates a chart inside a cell. Generates =SPARKLINE() Formula.

RegexMatcher Free For Members

Match patterns. Use regular expressions in Google Sheets.

RegexReplacer Free For Members

Replace any found text patterns in Google Sheets.

Conditional Formatter Free For Members

Create custom formulas for advanced conditional formatting.

Create Copy URL Free

Create a copy url to easily copy a Google Sheet.

Sheet to PDF Free

Export your Google Sheet to a PDF with just a URL.

Sheet to CSV Free

Export your sheets to CSV with just a URL.

Embed Spreadsheets Free

Create native embed code to host your sheets on a website.

SheetShot Free

Generate a high resolution screenshot your Google Sheet. Great for use on mobile.

OnlySheets Paid

Add a simple paywall your Google Sheets. Never lose a sale again.

Daily Tracker Free

Track habits, chores, or tasks with this free daily tracker.

Atomic Sheets Paid

100 unique Google Sheets elements. Pixel art you can use instantly.

Tiny Sheets Free

Delete unnecessary rows and columns in one click.

Sheet Styles Free

Add custom styles to your Google Sheets.

Button Styles Free

Add custom buttons to your Google Sheets.

Spintax Free

Parse Spintax inside your Google Sheets.

Discover More Tools >>>

Join to unlock more tools for your Google Sheets.