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​

​