Better Sheets - Better Conditional Formatting
For years I've railed against Conditional Formatting.
My tune is changing, today.
One reason I'm changing my tune is that it's far easier now to create custom formulas.
I made a Custom Formula Generator for Conditional Formatting.
It's free for members!
And if you're not a member: you got 3 free uses.
---
If you're reading all these emails lately, you'll notice I've been building lots of 1 page tools to make your Google Sheets experience better.
It might be hard to keep track of what you can do on Better Sheets these days.
I made a little directory. (see image below)
--
Why use custom formulas in Conditional Formatting?
You may need to highlight, or change the color of rows, based on multiple criteria. you have the clickable options in Conditional formatting like Greater Than or Less Than. But you also have Custom Formula. Which you can then use any formulas in there.
Most importantly you can use REGEX, or regular expressions to match specific patterns, specific words. It can be tough to figure this out on your own.
This tool does that for you. Just describe what you want to do, then paste it in your custom formula to try it out.
Go ahead, try it out!
Let me know what works, what doesn't. What else you want!
-Andrew
Your Resident Google Sheets Wizard at BetterSheets.co
Older messages
Never be flummoxed by formulas again! - Free Formula Generator
Wednesday, November 1, 2023
Never be flummoxed again! Your formula frustrations are over! I made a Formula Generator. And it's available right now. Enter your need, your data range, and hit the button. It'll generate a
Stop Worrying and Learn to Love Regex (FREE TOOL)
Monday, October 23, 2023
I have two questions for you: Have you ever tried to use Regex? Do you know what regex is? (Regular Expressions, used mainly to locate or validate specific strings or patterns of text in a sentence,
Free Course
Friday, October 20, 2023
Hi, It's Andrew from BetterSheets.co Here is a free course you can take: Learn to Code in Google Sheets. Takes less than 1 hour to get you familiar with Apps Script. I made this coupon code via
Is it easier?
Thursday, October 19, 2023
Hi, Just checking in to show you that I'm trying to make BetterSheets.co easier to navigate. Been adding little UI elements to make it easier to understand where to go, what can be done, etc. For
YouTube Thumbnail A/B Test Results
Tuesday, October 10, 2023
I cracked the code on YouTube's newest feature: Thumbnail A/B Testing If you're a Better Sheets member you can watch this tutorial and get the sheet right now -> Watch at BetterSheets.co
You Might Also Like
Closing 5/22 • For Authors • May Holiday Weekend Newsletter Promo + Social Media Posts
Saturday, May 18, 2024
For Authors ~ Join Our Book Newsletter for Summer Reading Enable Images to See This Join ContentMo's MAY 2024 Summer Reading Promotion & Get Your Book Emailed ~ Tweeted & posted to Facebook
Minimalism as a Tool
Saturday, May 18, 2024
A life of less stuff means a life of more focus and meaning.
The $1 billion test
Saturday, May 18, 2024
Will you pass?
• Promote a book series • all in one order w/ ContentMo •
Saturday, May 18, 2024
~ Book Series Ads for Authors ~ All in One Order! We want to help you get your book series out on front of readers. Our BOOK SERIES PROMO Packages can get you there! BOOK SERIES PROMOTIONS by ContentMo
The next round is on us--FREE Upgrade!
Friday, May 17, 2024
We've completely redone the small business buying course. And you're getting the new version for free. Hey No name, We've been working hard behind the scenes to bring you something new and
Help Me Decide What to Share
Friday, May 17, 2024
A poll!
Why it May Be Okay to Drop Beavers from Airplanes
Friday, May 17, 2024
But I wouldn't try it yourself.
How should you adopt LLMs? @ Irrational Exuberance
Friday, May 17, 2024
Hi folks, This is the weekly digest for my blog, Irrational Exuberance. Reach out with thoughts on Twitter at @lethain, or reply to this email. Posts from this week: - How should you adopt LLMs? How
Google penalises Site Reputation Abuse, starts rollout of AI Overviews
Friday, May 17, 2024
Immediately following the two-month grace period Google handed out manual penalties like candy at Halloween. Plus, Google I/O showed us the future of search. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Data is the only truth in business
Friday, May 17, 2024
Don't rely on outsourcing The world is pushing for stricter privacy policies: Safari has blocked all 3rd-party cookies from their browser. Google rolled out Tracking Protection to Chrome