Skip to main content

Multiple Conditional Formatting and Checkboxes in Sheets

 Last week I had a viewer of a video that I made in 2018 ask a question regarding conditional formatting and checkboxes. Now, when I created this video, it wasn't all that great. I still didn't want to talk on my tutorial videos, so I had music. Some loved it, others did not. I would like to think that I've evolved a bit since then, even if I did end up taking a year off as this was A YEAR like no other. 

While that video has had several views, I did have viewers asking questions. Now those that know me, know that I'm in spreadsheets for one reason or another, every single workday. It's what I enjoy, and well, it's needed for my day-to-day work duties. Since others might be visual learners, I thought I'd do another quick tutorial for those that might want to learn how to do multiple conditional formatting. These can be applied in whichever scenario you think you would need to work for you. That's the great thing about spreadsheets, everyone uses them for different reasons. 

I hope this short video tutorial will make more sense for you when you see it in real time. The formula used in the conditioning was =And($D2=1,$E2=1). 


Cheers, 

Beth

Comments

Post a Comment

Popular posts from this blog

What is it about this time of year?

  I'm not sure what it is about this time of the year that makes me think about doing tutorials. I know last year I went fast forward and even started working on podcasts, which unfortunately didn't get a lot of traction. I almost decided that this wasn't going to be worth it to start it up again. It took a lot of thought and a lot of angst on my end on what I should do. Then yesterday happened.  In a matter of hours, I had the pleasure of helping two different teachers with different walkthroughs on how to assist them with not only their data but how to switch things up for students in Slides if needed. It was all last minute, nothing was really planned out,  yet in a matter of two hours, I was able to light a spark within them as they learned something new.  This morning I then woke up to a new comment on a YouTube video that I did two years ago, that honestly wasn't that great compared to what I know now, but the comment was very touching. Some of them on that one...
Post a Comment
Read more

OTEDU S01 E07 - Google From Basics and Beyond

Google Forms is constantly changing. Let's face it, we push for more and more and they deliver. There's always something more to learn. I wanted you to see first hand how some things are done.  This episode of the OfficeTechEDU Podcast is done in a video screen sharing format for you to see not just what I'm clicking on but where. Learn all about the basics of creating a Google Form, how things work, and go beyond the basics. Redirect questions to a new series of questions based on the previous answers. You can watch the video version here . This one's a bit longer than normal, sorry. Beth
Post a Comment
Read more