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

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://www.theexcelchallenge.com

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
https://www.youtube.com/watch?v=lToTs9q-9Ow&t=3s

* TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically
https://www.youtube.com/watch?v=8jzHJ_kxxOA&t=15s

* TECH-008 - Create a chart with stacked pictures
https://www.youtube.com/watch?v=K7bAL5tkSMw

Видео TECH-011 - Create a calendar in Excel that automatically updates colors by event category канала The Excel Challenge