This is SO cool! Thank you for this tutorial! You made it so clear and answered a question I've been having for so long! It felt so good to automate this in my spreadsheet!

Ben, found your website and channel recently via googling, and like your stuff. More advanced than most, lovely tricks, nice manner. I see you've been inactive for 3 years, good to see you're uploading again. I'll be checking more of your materials. Keep it up, great job.

@benlcollins

5 ай бұрын

Thank you! Enjoy the new content. PS the website and newsletter have been active all this while ;)

Thank you very much, Ben. Your videos teach how to use spreadsheets in the everyday work with a nice touch of caring details, they are really useful.

@benlcollins

5 ай бұрын

You're welcome! Thank you 👍

really good explanations, thx

Fantastic way of teaching sir .. these days im working on something similar, I got frustrated with this color thing, you explained so easily and within 10 mins of your video all my issues are solved, thank you

thank you so much!! I was already searching for hours on something and thanks to this video, I could accomplish it 😘

Thanks. I learned a lot in this video.

@benlcollins

5 ай бұрын

You're welcome. Thanks!

Great video Ben!

@benlcollins

5 ай бұрын

Thanks, Danny!

Absolute legend

Hey, I have 3 columns of numbers I am trying to conditionally format for the ones who have the highest number to be highlighted a certain color. How do I do this across 2 columns?

Grate video! what about aggregative formula such as max? if I want to bold a cell that is the max out of the Colum?

Hi. How can I get a cell, in a group of cells, to mimic the format from another group of cells? This is also to consider that the 2nd group can be changed at any time.

Thanks!

@benlcollins

5 ай бұрын

Thank you 🙏

Hi Ben, do you have a post or link that explains all of the regexmatch modifiers such as .+ and $? For example, =REGEXMATCH($E2,".+Ross$") around 30:19. That was really useful and could not find anything except what you shared in this video. Would like to learn more!

@benlcollins

4 ай бұрын

Lots of examples in this post: www.benlcollins.com/spreadsheets/google-sheets-regex-formulas/ And here's the documentation: github.com/google/re2/wiki/Syntax I also have a REGEX course that is comprehensive: courses.benlcollins.com/p/google-sheets-regex-formula-cookbook/ Also, try ChatGPT or Bard. Both good at creating REGEX expressions for you. Hope this helps!

@adamagave

4 ай бұрын

@@benlcollins awesome thank you for the speedy reply, I'll take a look! Much appreciated

Hi Ben, a very interesting video. I use an annual spreadsheet and would like to highlight the columns where public holidays occur. I would like to know is there a way to highlight all the public holiday dates through conditional formatting or would I need to fill the columns in manually.

@benlcollins

5 ай бұрын

Yes, this sounds doable. If you have the public holiday dates in a separate table, then you can use a combination of the "date rule" and the "lookup rule" that I showed in this video to do it.

@robertnwardle

5 ай бұрын

Thank you Ben. Will try your suggestions

Great video, thank you. The correct title to help me find relevant content

Great video. But how do I add the same formatting rule to multiple ranges? I have tried adding additional ranges, but it is only the first range that gets formatted. The rest remains unformatted. Or is the only way to make a new rule for every single other range?

@benlcollins

4 ай бұрын

Thanks! To your question... it depends and it can be tricky, depending on the complexity of the conditional formatting rule. You can use the paintbrush tool to transfer a block of conditional formatting (see my basic CF video for example), or you can add ranges to the existing rules. But sometimes you just have to create a new rule because the custom formula needs to change.

@Nerosus

4 ай бұрын

@@benlcollins It is not complex, just a TRUE/FALSE condition. The ranges are in the list, but it is only the first range that is formattet: docs.google.com/spreadsheets/d/1N3z6TmO9GATNaeoSqk_E8QiRLKAelURTBcFHC6L45HA/edit?usp=sharing

The biggest issue I have had is knowing where to start constructing custom formulas in conditional formats. Most of what I have managed to achieve has been done purely by trial and error...

@benlcollins

5 ай бұрын

Hi, I recommend building the formulas in the Sheet first, get it working, and then transfer it to the custom formula rulebox. It's very hard to build long formulas directly in the conditional formatting sidebar.

@grahamlees4394

5 ай бұрын

@@benlcollins Thanks Ben.