Conditional Formatting to Do Merge and Center

[wachao]

Hi Experts,

I have a row in which data will look something like below -


Actual 0 0 0 0 Budget 0 0 0 0 Forecast 0 0 0 0 0 0 0 0


I want to merge all the cells for acutals, budget and forecast. So, first 5 cells Actuals followed by 4 zeros should be merged with value Actual. Next 5 as Budget and remaining ones as Forecast.

This needs to be dynamic i.e. Merge Actual with all the subsequent cells untily you hit budget..then merge budget until you hit forecast..and similarly merge forecast until you hit a non-zero value.

Please let me know how this can be achieved.

Regards,
Ashish