Formatting If Statement Code

[Chris Michaels]

Hi,

I am creating a model that does forecasting and planning for a company. I have a table with all the months in different columns and directly above it says either Actual or forecasting. I have a drop down list and I was hoping to use the drop down list to tell what cells to merge together and color as actuals and which to move together and color as forecasting.

For example if the drop down list is august then all the cells above January through August (D6:K6) would merge together and display "Actuals" in a dark blue formatting color and September through December cells (L6:O6) would merge together and display "Forecast" in a light blue formatting color. And further if the drop down only displayed February then only January and February (D6:E6) would be merged together and display "Actuals" and March through December (F6:O6) would merge together and display Forecast.

I attached a picture of the model. Any help would be extremely appreciated.

Thank you!!

[jaslake]

Hi Chris

This is a duplicate Thread. Please have a Moderator close one of them.

http://www.excelforum.com/excel-prog...nter-code.html