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
   • TECH-010 - Fill several blank cells (...  

* TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically
   • TECH-009 - Create a TOP 5 Chart (Pare...  

* TECH-008 - Create a chart with stacked pictures
   • TECH-008 - Create a bar chart with st...