Better Sheets

You've used your 2 free rules on this tool

Your last result is still on screen and copied. You only need membership to keep generating. Members get unlimited formula, sparkline, regexmatch, regexreplace, and conditional formatting generators, plus courses and tutorials when you’re stuck.

Free generations 2 / 2
  • Unlimited Formula, Sparkline, RegexMatch, RegexReplace, and Conditional Formatting generators
  • Step-by-step Google Sheets courses and tutorials
  • New tools and templates as they ship
Get lifetime access — $275 Start membership, $90/yr

Google Sheets tool

Conditional Formatting Generator

Describe the rule you want—highlight duplicates, compare columns, flag outliers—and get a custom formula ready to paste into Format → Conditional formatting.

Two fields. One click. Your rule copies to the clipboard when it’s ready.

Build your conditional formatting rule

Columns, comparisons, colors, or thresholds—be specific.

Blank defaults to A1.

2 free generations · Members generate without limits

Output

=AND($A1>10, $A1<100)

Rule library

Conditional formatting examples for Google Sheets

Duplicate emails, overdue dates, low stock, weekend calendars, and more. Load any card into the generator at the top of this page, or copy the custom formula into Format → Conditional formatting.

CRM Custom Formula CRM cleanup email marketing

Highlight Duplicate Email Addresses

Imported leads contain duplicate email addresses.

Apply to

Email column

Suggested range

A2:A

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=COUNTIF($A$2:$A,$A2)>1
  • highlight duplicates google sheets
  • duplicate email checker spreadsheet
  • remove duplicate leads
Productivity Date Alert contracts subscriptions

Highlight Expired Dates Automatically

Contracts, subscriptions, or invoices expire without notice.

Apply to

Due date column

Suggested range

B2:B

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=$B2<TODAY()
  • conditional formatting overdue dates
  • highlight expired dates
  • due date alerts spreadsheet
Inventory Threshold Alert warehouse management ecommerce

Highlight Low Inventory Levels

Inventory reaches dangerous low levels unnoticed.

Apply to

Inventory quantity column

Suggested range

C2:C

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=$C2<10
  • low stock alerts google sheets
  • inventory warning spreadsheet
  • stock management formatting
Project Management Row Highlight project management client work

Color Entire Rows Based on Status

Project trackers become difficult to scan visually.

Apply to

Project status column

Suggested range

A2:Z

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=$D2="Completed"
  • color row based on cell value
  • project tracker formatting
  • task status colors
Data Validation Blank Cell Alert CRM systems employee onboarding

Highlight Missing Required Fields

Important fields are left blank in forms and databases.

Apply to

Required information columns

Suggested range

B2:B

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=ISBLANK($B2)
  • highlight blank cells
  • missing data spreadsheet
  • required field alerts
Calendars Date Logic scheduling payroll

Highlight Weekend Dates Automatically

Need to visually separate weekends from workdays.

Apply to

Calendar date column

Suggested range

A2:A

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=WEEKDAY(A2,2)>5
  • highlight weekends google sheets
  • calendar conditional formatting
  • workday vs weekend
Sales Top Values sales dashboards KPI reports

Highlight Top Performing Sales Numbers

Top performers are hard to identify in large reports.

Apply to

Revenue or sales column

Suggested range

B2:B100

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=B2>=LARGE($B$2:$B$100,5)
  • highlight top values spreadsheet
  • top 10 sales conditional formatting
  • sales leaderboard sheets
Accounting Duplicate Detection bookkeeping procurement

Detect Duplicate Invoice Numbers

Duplicate invoices create accounting and payment errors.

Apply to

Invoice ID column

Suggested range

A2:A

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=COUNTIF($A:$A,$A1)>1
  • duplicate invoice detection
  • accounting spreadsheet errors
  • invoice validation sheets
Productivity Date Window project management launch planning

Highlight Upcoming Deadlines in the Next 7 Days

Upcoming deadlines are missed without visual warnings.

Apply to

Deadline date column

Suggested range

B2:B

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=AND($B2>=TODAY(),$B2<=TODAY()+7)
  • upcoming deadline alerts
  • due soon spreadsheet
  • project due dates
Analytics Heatmap analytics dashboards SEO tracking

Create Heatmaps for Large Data Tables

Large datasets are difficult to interpret quickly.

Use Format → Conditional formatting → Color scale on your range. No custom formula required.

Apply to

Large numerical data ranges

Suggested range

B2:F50

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Choose Color scale

Formatting

Color scale
  • heatmap google sheets
  • color scale spreadsheet
  • visualize large datasets
Support Regex Match customer support ticket triage

Highlight Cells Containing Specific Keywords

Urgent or dangerous messages are buried in large datasets.

Apply to

Support message column

Suggested range

A2:A

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=REGEXMATCH(A2,"urgent|asap|critical")
  • highlight keywords google sheets
  • regex conditional formatting
  • urgent ticket alerts
CRM Multi-Column Duplicate Detection CRM cleanup HR systems

Highlight Duplicate Names Across Multiple Columns

Duplicate contacts exist across first and last name combinations.

Apply to

First name + last name columns

Suggested range

A2:B

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=COUNTIFS($A:$A,$A2,$B:$B,$B2)>1
  • duplicate full names spreadsheet
  • conditional formatting multiple columns
  • detect duplicate contacts
AI Regex Review Alert AI publishing editorial workflows

Highlight AI Content That Needs Review

AI-generated content contains placeholders or unfinished sections.

Apply to

AI-generated content column

Suggested range

A2:A

Sheets setup

  1. Select your range
  2. Format → Conditional formatting
  3. Custom formula is → paste rule below

Custom formula

=REGEXMATCH(A2,"\[.*\]|TODO|FIXME|Lorem Ipsum")
  • ai content cleanup
  • placeholder detection spreadsheet
  • regex review workflows

Watch conditional formatting in action

Step-by-step rules: highlight duplicates, compare columns, color scales, and custom formulas.

Browse tutorials

Apply it in Sheets

Select your range, open Format → Conditional formatting, choose Custom formula is, and paste the generated rule.

Google’s official guide covers the full panel if you want a refresher.

Google Sheets help

Google Sheets Tools

Discover Google Sheets tools for anyone building spreadsheets, automations, and data workflows.

Formula Generator Free (Login)

Fix frustrating Google Sheets formulas fast.

Conditional Formatting Generator Free (Login)

Generate custom conditional formatting rules for Google Sheets.

Regex Replacer Free (Login)

Generate REGEXREPLACE formulas for Google Sheets.

Create Copy URL Free

Generate a copy URL for any Google Sheet.

Sheet to PDF Free

Export Google Sheet to PDF from a URL.

Sheet to CSV Free

Export Google Sheet to CSV from a URL.

Embed Spreadsheets Free

Generate embed code to publish sheets on your site.

Sell Daily paid

Generate daily social posts from a Google Sheet.

OnlySheets Paid

Add a simple paywall to your Google Sheets.

Daily Tracker Free

Track habits, chores, and tasks in one daily sheet.

Atomic Sheets Paid

100 ready-to-use Google Sheets templates.

Google Sheets Add-ons Free

Browse Sheet Styles, Spintax, Quiz Builder, and more — install from one place.

Tiny Sheets Free

Delete unnecessary rows and columns in one click.

Sheet Styles Free

Add custom styles to your Google Sheets.

SheetOps Paid

Business operations template for recurring tasks.

Spintax Free

Parse Spintax in Google Sheets to generate content variants.

Big Year Free

One-year calendar template for Google Sheets.

Discover More Tools →

Join to unlock more spreadsheet tools.

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons