Long range calendar with changing color based on user selection

I would like help with creating a long range calendar where columns E:NF change color based on the "section" selected by the user. Each section should be its own color. The conditional formatting currently is only gray based on the date range. I would like it to still function the same but just be a different color for each section. I am trying to avoid using the conditional format function because there are many more "sections" than in my example and the names change making maintenance of the conditional format formulas a nightmare. Thank you.

My apologies. After I re-read you post, I realized you wanted the color change to take place when the section in column A was changed. Please use this macro to do that.

Please Login or Register  to view this content.

The previous macro does the color change when either the start or end date is changed. Well now you have two options for doing the same thing.

Thank you Mumps1 for your response. Sorry, I cannot get the code to work. All it seems to do is remove the background color from the rows and add a light gray border. It is not changing the fill color to the corresponding color on the "Color Codes" tab based on the section chosen in column A. Please help!!

Try the attached file. It is working for me.

I don't understand, it doesn't work for me either. The macros are enabled but the cells are not being filled by color.

I don't know what to tell you. The file I attached works perfectly for me. It changes the color according to the Color Codes sheet. Maybe you could start a new thread on the forum, attach the file and explain the problem. I'm at a loss right now.