Conditional formatting changes based on user selection

[jrholden]

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.

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.
http://www.excelforum.com/excel-prog...selection.html