TECH-011 - Create a calendar in Excel that automatically updates colors by event category

Learn a quick trick to automatically change the event colors in your calendar, accordingly to the text you are entering in the different cells.

You will use simple concepts like autofill, select all, and conditional formatting.

I hope this trick is something you can use in your projects so you get more with less effort.

If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges of our viewers and subscribers.

Thank you for watching.

Check out some of our previous videos in the links below:

* TECH-010 - Fill several blank cells (empty cells) all at once

* TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically

* TECH-008 - Create a chart with stacked pictures

[mrCetus]

Actual life saver !!! was attempting to do this for at least an hour and you video helped me through it in 5 minutes !

[dminky]

This is a very effective tutorial on how to build a interactive calendar. Thanks!

[roomiesroom]

Wow! This is one of the best tutorials I have seen.

[JoseGarcia-znhw]

You explained very clearly and I only had to watch it like 7 times to get it, but thank you for time. Your awesome!

[notmichelle]

I need this so much, thanks a bunch. You're basically a life saver.

[reformerx]

This is super helpful. Ctrl + drag is the top.

[mirzajuaid]

Bro you’re simply dope .... I thought it will be very tough... you made it very easy... love you alot.

[billkoch]

This is genius -- thank you so much! I'm using this to create a content creation / review calendar for work. The formatting is great -- and numbering the days of the week with a formula is a huge time saver.

[vickaukraine]

I liked to follow very detailed examples shown in this video 😊. Thank you !

[ccpnavigator]

Excellent!! I am a beginner Excel user and was able to follow along and create a perfect usable calendar for work projects. Thank you for sharing!

[darylwhite]

I liked your demo.

A challenge for me: assigning people (2-4) for different shifts (2, 2hr shifts) for different locations (4-6 locations, varies by lication and by day) for a calendar.

[karladuenas]

You are the master! Thank you for posting this video! Blessings!

[lalalama]

Thank you for this video! It will help with my backward calendar assignment

[yarafortes]

This videos was very useful. Thank you so much🩷 keep up to good work.

[taniogbe]

So useful! Thank you so much for this very clear and detailed information!

[nancyj]

Awesome!! Very helpful for me.thanks!
Can you please make a tutorial of How to create a Swap schedule

[mariamaria]

Thank you so much for this!!!! Very easy to follow with you and I learnt alot!!! I am preparing a Training matrix for my job this was very helpful!!

[amber]

Awesome calendar and tutorial! Thank you!! And damn you type fast!!

[waellerbe]

Your video example is truly *amazing*. Can't thank you enough for sharing this incredible information with us here on YouTube. My appreciation for Excel has grown, thanks to the instruction that you shared. Continued blessings in return.

[elisan]

Thank you very much for this thoroughly informative video. You explain things so well. I truly appreciate your explanations.